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

98 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
ordinates104900(None) 
ordinate9310251ordinate_
coordinates1444102coordinates
iodinates1048202iodinates
odonates947742o_donates
ordinals946752ordina_ls
ordinances1344972ordinances
ordinands1143032ordinands
ordinaries1146252ordinaries
ordines83014902ordin__es
originates1145962originates
ruinates8311882_ruinates
urinates8314132ur_inates
abdicates1448153abdicates
alginates10310123alginates
arginases1046373arginases
arsenates979373arsenates
badinages13124873badinages
bombinates16105013bombinates
brominates1448013brominates
coordinate1344463coordinate_
coordinated1553513coordinated
cordites11314623cordi__tes
coronates1110816923cor_onates
craniates11310653craniates
criminates1448003criminates
crinites10612763cr_inites
dedicates13311693dedicates
dilates83220663__dilates
dominates12311743dominates
donates83217223__donates
drainages1145503drainages
eradiates102010783eradi_ates
eradicates1348263eradicates
fornicates1545843fornicates
fortunates1345263fortunates
frigates12310933fr_igates
geminates12310033geminates
germinates1347763germinates
indicates12312583indicates
inordinate1145943inordinate_
iodinate949343iodinate_
iodinated1146943iodinated
irrigates1057253irrigates
irritates977223irritates
laminates112712903laminates
loricates11310123lor_icates
marginates13168743marginates
marinates112516383marinates
mediates112814063medi_ates
medicates14312113medicates
meditates1239813meditates
nominates11311053nominates
obligates12207853obligates
obviates1345153obvi_ates
odonate848403o_donate_
opiates9312143o_pi_ates
oppilates1345453oppilates
orates64328613or___ates
ordinal838633ordina__l
ordinally1346283ordinally
ordinance1245053ordinance
ordinand1044103ordina_nd
ordinarier1153123ordinarier
ordinariest1253323ordinariest
ordinary1244913ordina_ry
ordination1149413ordination
ordinations1247993ordinations
ordnances1244753ord_nances
orientates1046043orientates
originate1047023originate_
originated1244813originated
ornate6315143or__nate_
orpines94414793orpin__es
ostinatos946173ostinatos
oxidates1636333o_xidates
ozonates1745963o_zonates
paginates123111363paginates
patinates113814693patinates
pollinates1247303pollinates
predicates15410823predicates
primates121515933pr_imates
privates131812373pr_ivates
pronates10418373pr_onates
radiates92415293radi_ates
radicates12412073radicates
resinates9314763resinates
ruinate7312833_ruinate_
ruinated939523_ruinated
ruminates11410193ruminates
sordines92414073sordin__es
subordinates1563393subordinates
supinates1139553supinates
terminates12410003terminates
turbinates1245773turbinates
urinate7315363ur_inate_
urinated9311613ur_inated
urticates1148893urticates

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 Limit148641986.79621871.8
3Display Results98980.0462130.4
 (SQL Overall)178691987.26524596.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.