Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “acquainting” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

67 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
acquainting235239(None) 
acquitting2243652acqu_itting
aquatinting2152352a_quatinting
reacquainting2551212reacquainting
acquaint1945723acquaint___
acquaintance256943acquaintance
acquainted2252003acquaint_ed
acquaints2042993acquaint__s
acquiring2144483acqu_i_ring
actuating1239233actua__ting
acuminating1645803ac_uminating
attainting1144783a_ttainting
quanting1849233__qua_nting
squinting1936223_squ_inting
abstaining1344574abstain_ing
accenting1487824ac__centing
acclaiming1743634acclai_ming
accounting1544924ac_counting
acquaintances266804acquaintances
acquiescing25111434acquiescing
actualizing2346204actualizing
acylating1547574acyla__ting
amounting1236644amou__nting
anointing1038624a__nointing
appointing1545324a_ppointing
aquatint1749434a_qua__tint
aquatintist2062534a_quatintist
arointing1049364a__rointing
attaining1047224a_ttain_ing
auditing1039034a__udi_ting
awaiting1238274a__wai_ting
bepainting15144884_bepainting
canting104725904_c__a_nting
captaining1546074captain_ing
chaining142810784_c_hain_ing
chanting143413534_c_ha_nting
chaunting1555414_c_haunting
counting113115274_cou__nting
depainting14156154_depainting
equating18310114_equa__ting
fainting123312164___fainting
impainting1544504_impainting
inquieting2044524inqu_ieting
liquating1946314liqua__ting
mispainting1645294mispainting
outpainting1445154outpainting
painting113614424___painting
quailing1838404__quai_ling
quantong1843494__qua_ntong
quieting18228464__qu_ieting
quilting18218714__qu_ilting
quintin163810334__qu_intin_
quintins17329864__qu_intins
quirting18238384__qu_irting
quitting18228834__qu_itting
quoining1835894__quoin_ing
quoiting1836094__quoi_ting
repainting13128974_repainting
requiting1939884requ_i_ting
sainting93215734___sainting
sandpainting1662084sandpainting
scanting113914764sc__a_nting
sequining1945324sequ_in_ing
squatting1934514_squa_tting
squirting1934794_squ_irting
tainting93613584___tainting
truanting1035604_trua_nting

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.420425454.8
2DLD Change Limit148819679.00016535.4
3Display Results67670.0332030.3
 (SQL Overall)178691679.45318903.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.