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

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

123 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
otalgies93639(None) 
otalgias944181otalgias
coxalgies1943242coxalgies
otalgia844482otalgi_a
otalgic1045062otalgi_c
otologies10311402otologies
staggies101210322staggies
talkies113415732_talkies
tallies73624602_tallies
aggies83515513__aggies
algins74816433__algins
alkies104518093__alkies
allies63827673__allies
analgias9107803analgias
analogies101910643analogies
antalgics1245173antalgics
ataxies142410013ata_xies
baggies113814853_baggies
baldies105317703_baldies
ballies93725743_ballies
bialies93618413bial_ies
botanies10312853bota_nies
botflies1336733botfl_ies
challies133915643challies
coxalgias1942423coxalgias
dallies84023193_dallies
dotages92311793dota_g_es
falsies103515013_falsies
fealties1139993fealties
gallies84122713_gallies
goalies8316023goal_ies
hoagies112811993hoa_gies
italics936993ital_ics
jaggies163311083_jaggies
lealties8310793lealties
loyalties1244483loyalties
mealies92821933meal_ies
myalgias14123893myalgias
nostalgias1152823nostalgias
nostalgics1352283nostalgics
notaries8314933nota_ries
obliges1037143o_bliges
octangles1243463octangles
oldies7314423o__ldies
ologies8615023o_logies
ontologies1139883ontologies
oologies9312993oologies
opalines10311423opalines
oralities91214123oralities
oranges84215333orang_es
orangier947713orangier
orangiest1038463orangiest
orgies72316093o__rgies
orologies10311623orologies
otalgy1035353otalg__y
outages82317323outa_g_es
outargues1044873outargues
outflies11310153outfl_ies
outlies72421993outl_ies
ovalities12119803ovalities
ovaries10312653ova_ries
oxalates1557063oxalates
oxalis1339223oxal_i_s
oxalises1538503oxalises
ozalids1794063ozal_ids
palsies94420273_palsies
potages102416423pota_g_es
raggies93214733_raggies
rallies73823343_rallies
realties8514853realties
retallies939373retallies
rotaries8315693rota_ries
royalties1244913royalties
sallies73227813_sallies
salties73725773_salties
stages75629493sta_g_es
staggie9138463staggie_
staggier10167513staggier
staggiest11148253staggiest
stagier83513443sta_gier
stagiest91613403sta_giest
stales65538293stal__es
stalkier1257073stalkier
stalkiest1347903stalkiest
stogies8413693st_ogies
swaggies13136693swaggies
tabbies112913503_tabbies
taffies133012693_taffies
taglines92210833_taglines
tales55451373_tal__es
talipes9611603_talipes
talkie103914443_talkie_
talkier114011843_talkier
talkiest123611223_talkiest
tallied83314753_tallied
tallier72817213_tallier
talliers83711373_talliers
tallis63319963_talli_s
tallises82713263_tallises
tallits73215993_tallits
taluses7311213_taluses
tammies113814683_tammies
tangier83013903_tangier
tangiest92915223_tangiest
tangles83920043_tangles
tansies74521243_tansies
tardies84225863_tardies
targes74524593_targ_es
tarries73324263_tarries
tassies74918933_tassies
tatties74120343_tatties
tawnies102812503_tawnies
tawpies12309873_tawpies
taxies135817333_ta_xies
tellies73820503_tellies
toadies82914863toa_dies
totalise8312503total_ise
totalises9311783totalises
totalities101210783totalities
totalizes18311053totalizes
votaries11312013vota_ries
walies95324523_wal_ies
wallies103320743_wallies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621236.57622226.6
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.04525364.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.