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

194 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
idolise83929(None) 
idolised1045671idolised
idoliser945041idoliser
idolises938761idolises
idolism1037271idolism
idolize1737781idolize
idealise938052idealise
idolisers1043702idolisers
idolisms1146352idolisms
idolized1946002idolized
idolizer1845662idolizer
idolizes1837552idolizes
idols65514132idol_s_
idylist1146652idylist
iodise74214942i_odise
iolite63221982i_olite
ionise63516942i_onise
isoline7314012isoline
abolish12311503abolish
adonis7314063adonis_
adonises92611433adonises
advise10139223ad_vise
agonise83112693agonise
aiolis6316843aiolis_
aldolase944773aldolase
atomise93013823atomise
azotise1637073azotise
bolide9515563_bolide
choline122915383choline
civilise1386253civilise
colies84837053_colies
coolie83821603cooli_e
coolies93824963coolies
coolish12312523coolish
creolise1037863creolise
delime9314043_delime
delis64928543_delis_
delish105215613_delish
delist74625053_delist
demise94618323_demise
devise104215753_devise
dialist8517763dialist
dialyse1135463dialyse
diddlies1137593diddlies
dillies84122153dillies
diocese1036853diocese
diols65521013diol_s_
diorite8314913diorite
dioxide1656303dioxide
dislike122913453dislike
dobie84920333_dobi_e
dobies94422093_dobies
docile94213123_docile
dogie75222793_dogi_e
dogies85022253_dogies
doglike13207453_doglike
doilies84017363_doilies
dolce85816683_dol_ce
dole56550003_dol__e
doles67843753_doles_
doling84923133_doling
dollies83620983_dollies
dollish11610093_dollish
dolls66126923_dolls_
dols56943053_dol_s_
doltish11118733_doltish
dolts65626313_dolts_
domine92918253_domine
donsie7613643_donsie
doolie73916833dooli_e
doolies83920713doolies
dories75232363_dories
dose56442433_do__se
douse66329723_do_use
dovish1338103_dovish
dowie94721143_dowi_e
dowse96020813_do_wse
doxie136017153_doxi_e
doxies143917853_doxies
doylies114512573_doylies
dulse65415043_dul_se
ebonise939613ebonise
eidolic1047063eidoli_c
enolase7310193enolase
finalise113112573finalise
foliose10378013_foliose
foolish1339613foolish
godlike1387563godlike
hoise85224773_ho_ise
holies94630033_holies
holism113713743_holism
holist94723213_holist
hoolie93217773hooli_e
icelike1337173icelike
idealised1145673idealised
idealises1047783idealises
idealism1147013idealism
idealist9310653idealist
idealize1847873idealize
idiocies1145223idiocies
idiotism1144553idiotism
idle55423763id_l__e
idles66720123id_les_
idlesse834193idlesse
idlest74014863id_lest
idling8912883id_ling
idocrase1183603idocrase
idol56818633idol___
idolater936863idolater
idolising1145893idolising
idolizers1944143idolizers
idylists1244123idylists
idyllist1243963idyllist
idylls10425253idylls_
idyls9498803idyl_s_
illite63414923i_llite
implies11312123implies
impolite1249293impolite
incise83515333i_ncise
incline9314643incline
inclose9910223inclose
indocile1146703indocile
indole74516053indol__e
indoles83716363indoles_
indols74714203indol_s_
indorse8108193indo_rse
induline939493induline
inklike1037033inklike
inosine7314273inosine
inosite7314063inosite
inulase739413inulase
iodide84812933i_odide
iodine74618653i_odine
iodised9329243i_odised
iodises83413633i_odises
iodism93611133i_odism
iodize164112593i_odize
iolites73819483i_olites
ionised82911493i_onised
ionises72916433i_onises
ionize154613873i_onize
ironies7517423ironies
ironist7314843ironist
ironize16610373ironize
ironlike1235713ironlike
isocline1047293isocline
isodose845373isodose
isolate7313923isolate
isolines8312303isolines
itemise997453itemise
ivories10310713ivories
ivylike1734283ivylike
kaoline11310143kaoline
kidlike1137063kid_like
lionise7310373lionise
midlife13248303mid_life
midline102315103mid_line
midlist10312513mid_list
molies84429513_molies
moline84422033_moline
nicoise937923nico_ise
noise55723733_no_ise
nowise9511073_nowise
obelise9310173obelise
odalisk1265373odalisk
odorize1737403odorize
olive84817153__olive
oolite63319603_oolite
ozonise1646443ozonise
picoline12310853picoline
pisolite10310363pisolite
podlike14108553podlike
poise75127893_po_ise
police102918563_police
polies84034583_polies
polis74731163_polis_
polish114916723_polish
polite83625073_polite
proline92321593proline
promise113415843promise
realise73021813realise
rodlike1288263rodlike
sideline91011093sideline
sidewise1245353sidewise
stylise10208953stylise
tidelike1336743tidelike
utilise749063utilise
valise92917643_valise
violist10312143violist
vitalise11310743vitalise
wholism1535873wholism
woolie93514483wooli_e
woolies104117363woolies
zeolite1638903zeolite

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271947.12318816.1
3Display Results1941940.0633079.4
 (SQL Overall)1786911947.34224338.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.