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

103 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
idealise93805(None) 
idealised1145671idealised
idealises1047781idealises
idealism1147011idealism
idealist9310651idealist
idealize1847871idealize
idealess935652idealess
idealisms1246442idealisms
idealists1047222idealists
ideality1247152ideality
idealized2046652idealized
idealizer1945472idealizer
idealizes1947392idealizes
ideals75012502ideal_s_
ideative1238572ideative
idolise839292id_olise
realise73021812_realise
alkalise12178043alkalise
canalise10816213canalise
creolise1037863creolise
deadline10139053_deadline
deafish1438533_deafish
dealate83617843_dealate
dealfish1545503_dealfish
dealing94323233_dealing
deals65435343_deal_s_
dearie73319813_deari_e
dearies83526273_dearies
decline103716613_decline
delaine8314793_delaine
delime9314043_de_lime
delis64928543_de_lis_
delish105215613_de_lish
delist74625053_de_list
dellies83622213_dellies
demise94618323_de_mise
despise1038683_despise
devise104215753_de_vise
dialist8517763_dialist
dialyse1135463_dialyse
dualism1049163_dualism
dualist8614053_dualist
dualize1759763_dualize
equalise1748213equalise
finalise113112573finalise
focalise131210373focalise
icelike1337173ice_like
ideal65716393ideal___
idealising1245703idealising
idealistic1344703idealistic
idealities1148783idealities
idealizers2043703idealizers
idealless1042953idealless
ideally1137793ideal_ly
idealogies1244193idealogies
idealogue1152493idealogue
idealogy1342943idealogy
ideas65919013idea__s_
ideate7313683idea__te
ideates8313733ideates_
ideating10311703ideating
ideation9310493ideation
idolised1045673id_olised
idoliser945043id_oliser
idolises938763id_olises
idolism1037273id_olism
idolize1737783id_olize
idylist1146653id_ylist
idyllist1243963idyllist
itemise997453ite_mise
legalise949493legalise
liberalise1247593liberalise
linearise946433linearise
localise101511853localise
mealie82519813_meali_e
mealies92821933_mealies
medalist11414213medalist
metalise10416053metalise
mineralise1248183mineralise
moralise10314913moralise
nasalise848863nasalise
obelise9310173obe_lise
odalisk1265373od_alisk
pealike131211273_pealike
penalise101013763penalise
realised92214533_realised
realiser82512563_realiser
realises82420183_realises
realism93115923_realism
realist73225383_realist
realize162717083_realize
ruralise839643ruralise
sideline91011093side_line
sidewise1245353side_wise
signalise1046393signalise
tealike111111083_tealike
tidelike1336743tide_like
totalise8312503totalise
treatise8311103treatise
valise92917643__valise
visualise1245613visualise
vitalise11310743vitalise
vocalise131510813vocalise

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.403443402.0
2DLD Change Limit1461621036.89321204.4
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.34224338.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.