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

152 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
insular713870(None) 
insulars8137321insulars
angular838532angular
annular737692annular
cingular11256972cingular
consular1038812consular
insofar1043542insofar
instar6310012ins_tar
insulant849872insulant
insularly1245322insularly
insulate8312842insulate
insulator948102insulator
insulin738482insulin
insult62813672insul_t
insulter836882insulter
insults7268962insults
insurer73312802insurer
lingular9407502lingular
pinnular1044432pinnular
singular9327562singular
tissular843812tissular
undular837122undular
ungular836772ungular
alular6311353_alular
anovular1144163anovular
ashlar9338193_ashlar
basilar937303basilar
binocular1394603binocular
biovular1343603biovular
cannular1046283cannular
canular9310323canular
capsular1245403capsular
cingula10327173cingula_
circular1247903circular
copular113810603copular
cupular11317623cupular
desugar944033desugar
ensurer73011903ensurer
fabular12288693fabular
facular122810443facular
fibular12267973fibular
fistular1144253fistular
gular6314833__gular
hamular1236973hamular
incudal1045863incudal
incult82414773incul_t
incur72212253incu__r
inducer10318763inducer
indulge945403indulge
indulger1044153indulger
indulin838773indulin
indult73614033indul_t
indults8289493indults
infuser10298323infuser
ingulf10310353ingul_f
ingulfs1134733ingulfs
inhaler1068053inhaler
inhauler1163943inhauler
inhuman1265483inhuman
inhumer1275383inhumer
injurer14318473injurer
inlay85214323in__lay
inocula947263inocula_
insaner7310443insaner
insculp1143793inscul_p
insculps1243393insculps
inseam8329993ins_eam
insider849733insider
insnare748243ins_nare
insolate8311893insolate
insole63515863insol_e
insoles73516243insoles
insoul638463insoul__
insouled936113insouled
insouls737213insoul_s
inspan837513ins_pan
instal6712193ins_tal
install779363install
instals7611713instals
instars7411133ins_tars
instead836203instead
insulants946913insulants
insularism1253723insularism
insularity1354523insularity
insulated10310713insulated
insulates9311843insulates
insulators1047263insulators
insulins848863insulins
insulted937193insulted
insulters945883insulters
insurant8411423insurant
insure63416603insu_re
insured83714253insured
insurers83710133insurers
insures73117263insures
inulase739413in_ulase
inulin6311733in_ulin
invar839513in__var
isobar836143i_sobar
issuer646623issu_er
jocular1637303jocular
jugular1534513jugular
ligular8348533ligular
lingula8428803lingula_
lingulae9357033lingulae
lobular936663lobular
locular938953locular
lunular736013lunular
macular113011943macular
modular1087363modular
morular978223morular
muscular1246243muscular
mutular936643mutular
nebular956483nebular
nodular876703nodular
nonsolar847083nonsolar
nonsugar944363nonsugar
ocular8610133_ocular
oscular937933oscular
ovular946833_ovular
pabular11259473pabular
papular11299763papular
pendular1144943pendular
peninsular1251983peninsular
piacular1246573piacular
pilular938203pilular
pinnula934913pinnula_
pinnulae1044183pinnulae
popular11319563popular
pustular1045153pustular
radular837833radular
ranular739433ranular
regular838423regular
secular92211533secular
simular938673simular
singulars10305633singulars
solar55927343__solar
sugar6312913__sugar
tabular9279763tabular
tegular836603tegular
titular737523titular
tonsilar843953tonsilar
tubular9267473tubular
tumular9236543tumular
ungula737603ungula_
ungulae837313ungulae
unswear1035003unswear
uvular955563_uvular
vascular1346293vascular
venular1037683venular
vincula1246393vincula_
zonular1656493zonular

Search took 7 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.406440125.6
2DLD Change Limit1340271526.40620922.1
3Display Results1521520.0602533.3
 (SQL Overall)1786911526.87226002.8
 
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.