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

127 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
insolates931127(None) 
insolate8311891insolate_
insolated1039711insolated
insulates9311841insulates
isolates8613511i_solates
desolates10311792desolates
immolates1346452immolates
inflates11512192in_flates
innovates1245522innovates
insoles73516242insol__es
instates81615832ins_tates
insulate8312842insulate_
insulated10310712insulated
intonates9410242intonates
invocates1447642invocates
involutes1245102involutes
isolate7313922i_solate_
isolated9410522i_solated
solates73523852__solates
absolutes1144523absolutes
angulates10310863angulates
annotates977293annotates
anolytes11169213an_olytes
apholates1449683apholates
cholates132414763_cholates
consulates12711103consulates
desolate9411993desolate_
desolated1139653desolated
desolater1038383desolater
desolaters1146043desolaters
endplates1246843endplates
enolases8411013en_olases
ensilages1044433ensilages
enslaves1136393ens_laves
etiolates949213etiolates
folates103218453__folates
idolater936863i_dolater
idolaters1045713i_dolaters
immolate1246543immolate_
immolated1444873immolated
incubates1347603incubates
inculcates1446563inculcates
inculpates1445973inculpates
indagates1146573indagates
indicates12312583indicates
indoles83716363indol__es
indurates10310693indurates
inflames1377323in_flames
inflate10312313in_flate_
inflated12410863in_flated
inflater1149893in_flater
inflaters1247543in_flaters
ingates82716913in__gates
ingrates9514173in_grates
initiates9411183initiates
inlaces92512903in__laces
inmates92715783in__mates
innovate1145643innovate_
innovated1344573innovated
inoculates1248703inoculates
inosculates1345143inosculates
inosites8312793in_osites
inscapes1237813ins_capes
insheathes16143573insheathes
insheaths15183503insheaths
insinuates1045463insinuates
insnares858083ins_nares
insolating1149153insolating
insolation10410213insolation
insolations1149183insolations
insole63515863insol__e_
insolences1247113insolences
insolents9137523insolents
insolubles1253013insolubles
instate71616483ins_tate_
instated91613343ins_tated
instigates1148423instigates
insufflates17132403insufflates
insulants946913insulants
insulars8137323insula_rs
insulator948103insulator
insulators1047263insulators
insulted937193insul_ted
insulter836883insul_ter
insulters945883insul_ters
insults7268963insul_t_s
inswathes1543953ins_wathes
intimates111013313intimates
intonate8310923intonate_
intonated1048303intonated
intubates1147123intubates
inulases838763in_ulases
inundates1045773inundates
inviolate1246393inviolate_
invocate1347833invocate_
invocated1546203invocated
involute1145473involute_
involuted1354343involuted
involves1444973invol_ves
iodates8312903i__odates
iolites73819483i__olites
isobares1046513i_sobares
isobaths1343833i_sobaths
isolator847533i_solator
isolators947513i_solators
isolines8312303i_solines
lineolate946283lineolate_
linoleates1044963lin_oleates
neonates8310063_neonates
niobates1037283_niobates
notates72817483_n_otates
obsoletes1144213obsoletes
pisolites1149383pisolites
reslates83619503res_lates
resolutes968193resolutes
resonates9412403resonates
slates64934063__s_lates
solaces93116133__solaces
solate64526073__solate_
solated83618023__solated
solutes73515263__solutes
solvates11249673__solvates
tinplates1147773tin_plates
undulates1048923undulates
ungulates1048353ungulates
unstates81314993uns_tates
violates11311193_violates

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.453394461.4
2DLD Change Limit1486411277.17320722.3
3Display Results1271270.0761671.1
 (SQL Overall)1786911277.70223200.6
 
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.