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

146 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
insolate831189(None) 
insolated1039711insolated
insolates9311271insolates
insulate8312841insulate
isolate7313921i_solate
desolate9411992desolate
immolate1246542immolate
inflate10312312in_flate
innovate1145642innovate
insole63515862insol__e
instate71616482ins_tate
insulated10310712insulated
insulates9311842insulates
intonate8310922intonate
inviolate1246392inviolate
invocate1347832invocate
involute1145472involute
isolated9410522i_solated
isolates8613512i_solates
lineolate946282lineolate
solate64526072__solate
absolute1044483absolute
angulate9312013angulate
annotate877713annotate
annulate8310923annulate
anolyte10159003an_olyte
ansate64517863ans__ate
apholate13410473apholate
areolate81014453areolate
cholate122114933_cholate
ciliolate1145973ciliolate
cingulate12238603cingulate
consulate11612233consulate
desolated1139653desolated
desolater1038383desolater
desolates10311793desolates
dissolute1045753dissolute
endplate1147083endplate
enolase7310193en_olase
ensilage944713ensilage
enslave1036273ens_lave
etiolate849523etiolate
folate93320393__folate
idolater936863i_dolater
immolated1444873immolated
immolates1346453immolates
impolite1249293impolite
inchoate1347673inchoate
increate10312203increate
incubate1238663incubate
incudate1138873incudate
inculcate1347433inculcate
inculpate1346793inculpate
indagate1047193indagate
indicate11313353indicate
indole74516053indol__e
indurate9311873indurate
inflame1256963in_flame
inflated12410863in_flated
inflater1149893in_flater
inflates11512193in_flates
ingate73018243in__gate
ingrate8715123in_grate
initiate8412693initiate
inlace82513043in__lace
inmate82917363in__mate
innate63917313in__nate
innovated1344573innovated
innovates1245523innovates
inoculate1149623inoculate
inosculate1245923inosculate
inosite7314063in_osite
insane6314893ins__ane
insatiate948063insatiate
inscape1138023ins_cape
insensate945393insensate
insheath14114423insheath
insheathe15163883insheathe
insinuate945963insinuate
insnare748243ins_nare
insofar1043543insofa_r
insolating1149153insolating
insolation10410213insolation
insolence1147203insolence
insolent81311553insolent
insolents9137523insolents
insoles73516243insol_es
insoluble1144243insoluble
insolvable1545363insolvable
instated91613343ins_tated
instates81615833ins_tates
instigate1048613instigate
insufflate16122453insufflate
insulant849883insulant
insulants946913insulants
insular7138703insula_r
insulars8137323insulars
insulator948103insulator
insult62813673insul_t_
insulted937193insul_ted
insulter836883insul_ter
insults7268963insul_ts
inswathe1443693ins_wathe
intimate101013833intimate
intonated1048303intonated
intonates9410243intonates
intubate1047533intubate
inulase739413in_ulase
inundate946043inundate
invocated1546203invocated
invocates1447643invocates
involuted1354343involuted
involutes1245103involutes
involve1345093invol_ve
iodate7313503i__odate
iolite63221983i__olite
isobare946343i_sobare
isobath1244613i_sobath
isolable1038793i_solable
isolator847533i_solator
isoline7314013i_soline
lingulate10368193lingulate
linoleate944733lin_oleate
neonate7311333_neonate
niobate937703_niobate
notate63217863_n_otate
obsolete1044313obsolete
pinnulate1145763pinnulate
pisolite10310373pisolite
prolate9419793_prolate
reslate73520593res_late
resolute868513resolute
resonate8513513resonate
rosulate8310903rosulate
slate55438283__s_late
solace83415823__solace
solated83618023__solated
solates73523853__solates
solute64016663__solute
solvate102710213__solvate
tinplate1047743tin_plate
undulate9310403undulate
ungulate939803ungulate
unpolite1049173unpolite
unstate71916213uns_tate
violate10311553_violate

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 Limit1461621466.82621412.5
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.31224438.0
 
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.