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

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

97 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
allotting104650(None) 
allocating1347382allocating
allowing12369092allo_wing
alloying12339142allo_ying
balloting1238392ballo_ting
blotting113910432_blotting
clotting113110642_clotting
lotting82917752__lotting
plotting113011012_plotting
reallotting1243672reallotting
slotting92612612_slotting
abetting1158293a_betting
ablating11312003abl_ating
aborting11710253a_borting
abutting1137003a_butting
accosting1446733accosting
admitting1345033admitting
adopting1237453a_dopting
alerting91312383a_lerting
alighting1446413alighting
allaying12339313all_aying
alleging1038473all_eging
allotment1146333allotment
allotted986873allott_ed
allottee887123allott_ee
allottees964323allottees
allotter866473allott_er
allotters965563allotters
alluding1036953all_uding
alluring939073all_uring
allying113011663all__ying
annotating1146233annotating
assorting1037303assorting
ballasting1345303ballasting
ballooning1344723ballooning
besotting12256873besotting
blatting114111653_blatting
bloating113512813_bloating
callousing1344273callousing
clothing14278783_clothing
clouting113011683_clouting
coplotting1555953coplotting
dotting93314483__dotting
fallowing1666433fallo_wing
flatting123511253_flatting
flitting123010883_flitting
floating123111883_floating
flouting122610473_flouting
gallanting1245353gallanting
galleting1137633gall_eting
galloping1356253gallo_ping
garotting1136113garotting
garrotting1254203garrotting
gavotting1443193gavotting
gloating102611463_gloating
glouting10379693_glouting
glutting10247643_glutting
halloaing1387033hallo_aing
halloing121510073hallo__ing
hallooing1366343hallo_oing
hallowing1676943hallo_wing
hotting113116523__hotting
inletting1087873inletting
jotting152912773__jotting
knotting13236573_knotting
letting83218533__letting
lofting113311313__lofting
looting83019643__looting
louting83719383__louting
misallotting1552113misallotting
palleting1238743pall_eting
palliating1347893palliating
piloting1139693pilo_ting
platting114813033_platting
plotzing20276153_plotzing
potting103720893__potting
preallotting1551993preallotting
reletting102713943reletting
replotting1357043replotting
repotting12511123repotting
rotting82919683__rotting
sallowing1357383sallo_wing
shotting123012383_shotting
slatting94014233_slatting
slitting93012583_slitting
splatting1235983splatting
splitting1236563splitting
spotting112812093_spotting
stotting92811163_stotting
swotting12268483_swotting
tabletting1344093tabletting
tallowing1366293tallo_wing
totting82816843__totting
trotting92510913_trotting
walloping1545593wallo_ping
wallowing1666073wallo_wing
wotting112913843__wotting

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641977.11020905.9
3Display Results97970.0303233.3
 (SQL Overall)178691977.56323627.0
 
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.