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 “reallocations” 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.

90 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
reallocations155380(None) 
reallocation1454491reallocation_
allocations1347772__allocations
reallocating1573662reallocati_ng
relocations13311142re__locations
allocation1248573__allocation_
allocutions1353983__allocutions
collocations1646403_collocations
misallocations1853093misallocations
realizations21415533rea_lizations
reallocates1354333reallocat__es
reapplications2054253reapplications
relocation12312113re__location_
replications16811053re_plications
revocations16410313re__vocations
suballocations1861483suballocations
advocations1755414__advocations
allegations1246044__allegations
allocating1347384__allocati_ng
allocators1246084__allocat_ors
allocution1244084__allocution_
avocations15168684__a_vocations
bilocations1545294__bilocations
collocation1547174_collocation_
dealations11311374dea_l__ations
defalcations1845194defal_cations
deflorations1646064de_florations
dislocations15136984_dislocations
echolocations2052624echolocations
elaborations1444924_elaborations
elocutions1245964_e__locutions
embrocations1843984_embrocations
eradications1549304era_dications
evocations15259874_e__vocations
explications2347534_explications
explorations2185614_explorations
fellations1338064fe_ll__ations
lallations1038744_lall__ations
locations112512744____locations
meliorations1466754me_liorations
metallizations25126504metallizations
misallocation1753364misallocation_
mislocations16145654_mislocations
palliations1347724_pall_iations
reactions11711714rea___c_tions
reactivations18176144reactivations
realization20417224rea_lization_
reallocate1254424reallocat___e
reallocated1443774reallocat__ed
reallotting1243674reallo_tti_ng
reanimations1468784rea_nimations
reannexations2052834reannexations
reapplication1954724reapplication_
reapportions1653654reappo_rtions
recalculations18104034recalculations
recalibrations1853694recalibrations
reciprocations20203384reciprocations
reclamations1645714re_clamations
recollections1754724recollec_tions
redecorations1645084redecorations
rededications1746124rededications
reduplications1964534reduplications
reeducations1545474re_educations
reelections13167944re_elec_tions
reflations13311234re_fl__ations
reflections16178554re_flec_tions
regulations12310714regul__ations
reifications17411824re_ifications
relations92418334re__l__ations
relaxations1845644re__laxations
relegations1248974re__legations
relictions12310024re__lic_tions
relocating13310874re__locati_ng
reluctations1446754re_luctations
renovations1448424re__novations
replantations1544864replantations
replication15712014re_plication_
reprobations1647774re_probations
republications2074454republications
restorations12410954re_storations
retaliations12511404retal_iations
retroactions1447074re_troactions
revalidations1747114revalidations
revaluations1557634reval_uations
revelations14410304revel__ations
revocation15410814re__vocation_
spallations1356104spall__ations
suballocation1761624suballocation_
translocations1664234translocations
vallations1339094_vall__ations

Search took 6 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 Filter178691950240.423422437.4
2DLD Change Limit95024904.92019313.8
3Display Results90900.0631428.6
 (SQL Overall)178691905.40633054.2
 
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.