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 “reacquainting” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
reacquainting255121(None) 
acquainting2352392__acquainting
reacquaint2153023reacquaint___
reacquainted2451233reacquaint_ed
reacquaints2251543reacquaint__s
reacquiring2352653reacqu_i_ring
acquitting2243654__acqu_itting
aquatinting2152354__a_quatinting
reaccenting1665014reac__centing
reacclaiming1951984reacclai_ming
reanointing1244994rea__nointing
reappointing17122934rea_ppointing
reattaining1244594rea_ttain_ing
recanting122414824re_c__a_nting
recounting1339194re_cou__nting
recruiting1347904re_cru_i_ting
repainting13128974re___painting
requiting1939884re__qu_i_ting
acquaint1945725__acquaint___
acquaintance256945__acquaintance
acquainted2252005__acquaint_ed
acquaints2042995__acquaint__s
acquiring2144485__acqu_i_ring
actuating1239235__actua__ting
acuminating1645805__ac_uminating
attainting1144785__a_ttainting
bearbaiting1643165bea_rbai_ting
bepainting15144885be___painting
decanting132510635de_c__a_nting
depainting14156155de___painting
descanting1446925desc__a_nting
desquamating2551755de_squamating
enchaining1644945_enc_hain_ing
enchanting1645945_enc_ha_nting
equating18310115_e__qua__ting
evacuating1645685evac_ua__ting
excruciating2452375_excruciating
frequenting2443275fre__qu_enting
headhunting1951795headhu__nting
merchanting1944315merc_ha_nting
quanting1849235____qua_nting
reaccepting1863895reac__cepting
reaccrediting1961485reaccrediting
reaccusing1543995reaccu___sing
reacquisition2481485reacquisition
reacquisitions2581345reacquisitions
reacting113317895reac_____ting
reactivating1844755reac_tivating
readapting1445155rea__da_pting
readdicting1643815rea__ddicting
readjusting2042905readju__sting
readmitting1544055rea__dmitting
reanimating1447235reanima__ting
reappraising1762845reapprai_sing
rearranging1343785rea_rra_nging
reassailing1244105rea_ssai_ling
reavailing1444875rea__vai_ling
rebaiting12311645re___bai_ting
recaning111416695re_c__a_n_ing
recasting122414235re_c__a_sting
recautioning1553765re_cautioning
receipting1546755re_c__eipting
recementing1645225re_c_ementing
rechanging1746045re_c_ha_nging
recharting1637215re_c_ha_rting
reciting113118075re_c___i_ting
reclaiming1546585re_c_lai_ming
recleaning1336755re_clea_n_ing
reclining121112285re_c__lin_ing
recoating121317465re_c_oa__ting
recoining121313805re_c__oin_ing
recombining1844455re_combin_ing
recommitting1954135re_committing
reconfining1745115re_confin_ing
reconvicting20114625re_convicting
reconvincing2053165re_convincing
recrating121318795re_c_ra__ting
recreating131214585re_crea__ting
recriminating1864935re_criminating
recutting1239485re_c_u__tting
redbaiting1446265re__dbai_ting
reequipping2551395re_equ_ipping
reexplaining2251955reexplain_ing
refraining1437265re__frain_ing
regaining112411085re___gain_ing
regranting1238325re__gra_nting
reimplanting1752625reimpla_nting
relacquering2451775relacqu__ering
relumining1345645re__lumin_ing
remaining122212795re___main_ing
reminting122315105re____minting
remounting1346675re_mou__nting
reobtaining1443535re_obtain_ing
reordaining1343455re_ordain_ing
replanting1338525re__pla_nting
reprinting131510585re___printing
repudiating1546205re__pudiating
requalifying2872665re__qualifying
requesting2046315re__qu_esting
requiring1937045re__qu_i_ring
rescinding1436725resc___inding
resculpting1643455resc_u_lpting
resituating1247545resitua__ting
restraining1247535re_strain_ing
retaining102114735re___tain_ing
retinting102215255re____tinting
retraining11310245re__train_ing
reuniting10310695re___uni_ting
revaccinating2152705revac__cinating
revaluating1545895revalua__ting
sandpainting1662085_sandpainting
sequining1945325se__qu_in_ing
squinting1936225___squ_inting
unacquainted2451135unacquaint_ed

Search took 9 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901148.31315011.4
3Display Results1141140.0631809.5
 (SQL Overall)1786911148.76620384.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.