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

234 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
insaner731044(None) 
inaner62213541in_aner
insane6314881insane_
inane52820342in_ane_
inanes62519802in_anes
inhaler1068052inhaler
inlander937222inlander
inlayer1036932inlayer
inner54920632in__ner
insanely1146122insanely
insanest8410342insanest
insider849732insider
insnare748242insnare
insnarer865302insnarer
instanter946242instanter
insurer73312802insurer
intoner7811672intoner
invader11146452invader
saner54334322__saner
ansae55720973ansa_e_
ansate64517863ansate_
ansated84214003ansated
answer936893ans_wer
assayer1035573assayer
caner75334773__caner
cleaner93712303cleaner
dinner74217163din__ner
endanger1045853endanger
engager9278603engager
enhancer1346683enhancer
enslaver1144713enslaver
ensnare767123ensnare
ensnarer874473ensnarer
ensurer73011903ensurer
essayer1033943essayer
gainsayer1342133gainsayer
ginner73915823gin__ner
gleaner8379773gleaner
gnawer10386953gn_awer
groaner82510133groaner
humaner12257663humaner
imager9108123i_mager
immane1038883immane_
impaler11298393impaler
impanel1137093impanel
inanely1037943in_anely
inanest72115363in_anest
incage93513623incage_
incaged114010443incaged
incages103013883incages
incant82418503incan_t
incanted11259543incanted
incants92012803incants
incase83615283incase_
incased103612393incased
incases93615973incases
incenter102212093incenter
incher114114033in_cher
inciter93113773inciter
incliner1038513incliner
incomer1169943incomer
indene73215373indene_
indenes82916253indenes
indenter92311443indenter
indexer15287253indexer
inditer83514233inditer
inducer10318763inducer
infancy1546173infancy
infant92315133infan_t
infanta10237253infanta
infante101910883infante
infantes11249633infantes
infantry1443853infantry
infants102210773infants
infare9313083infare_
infares10313023infares
infer84215033in__fer
inflamer1356123inflamer
inflater1149893inflater
infuser10298323infuser
ingate73018243ingate_
ingates82716913ingates
ingather1244783ingather
inhale9411513inhale_
inhaled1169333inhaled
inhalers1166643inhalers
inhales10511863inhales
inhauler1163943inhauler
inhumer1275383inhumer
injurer14318473injurer
inker94421093in__ker
inkier104013783in_kier
inlace82513043inlace_
inlaced10239873inlaced
inlaces92512903inlaces
inland7310313inlan_d
inlanders1036143inlanders
inlands838783inlands
inlayers1135643inlayers
inlier63615363in_lier
inmate82917363inmate_
inmates92715783inmates
innage73011573innage_
innages82911303innages
innate63917313innate_
inned64118423in__ned
inners63919353in__ners
inosine7314273inosine_
inosines8312703inosines
insanity1147333insanity
inscape1138013inscape_
inscapes1237813inscapes
insert64325253ins__ert
inserter82312133inserter
inset54430863ins__et
insetter8218593insetter
inshore1038723inshore
inside7613453inside_
insiders947763insiders
insides8512653insides
insigne837673insigne_
insincere1143683insincere
insister888783insister
insnared956123insnared
insnarers954433insnarers
insnares858083insnares
insofar1043543insofar
insole63515863insole_
insoles73516243insoles
inspan837513inspan__
inspanned1242853inspanned
inspans937803inspan_s
insphere1355973insphere
inspire938253inspire
inspirer1045183inspirer
installer945003installer
instance1049873instance
instanced1245693instanced
instances1148743instances
instancy1346563instancy
instant7815343instan_t
instants8910153instants
instar6310013ins_tar
instate71616483instate_
instated91613343instated
instates81615833instates
instep838193ins_tep
insular7138703insular
insulter836883insulter
insure63416603insure_
insured83714253insured
insurers83710133insurers
insures73117263insures
intake10510863intake_
intakes11310943intakes
integer837993integer
intender93310443intender
intenser8199443intenser
inter55028493in__ter
intine61021983intine_
intines7921113intines
intone61115433intone_
intoned8811993intoned
intoners889933intoners
intones7816543intones
intranet8418443intranet
inurned8328053inurned
invade10157853invade_
invaded12127043invaded
invaders12105303invaders
invades11118293invades
invar839513inva__r
inventer112410843inventer
inviter104112313inviter
invoker1435363invoker
irater65218353i_rater
ironer64216453i_roner
islander946103islander
isomer8310153i_somer
issuer646623i_ssuer
kneader1275893kneader
leaner64022193_leaner
lindane839033lindane_
lindanes939173lindanes
linsang835863linsan_g
linsangs944413linsangs
loaner64416503_loaner
meaner84617843_meaner
minster93914323mins_ter
misaver1249813misaver
moaner84415113_moaner
namer75622103_n_amer
nearer64618893_nearer
neater64424313_neater
onager739663on_ager
pilsener1044753pilsener
pilsner935343pils_ner
pinaster1037113pinaster
pinner84521503pin__ner
pinscher1544803pinscher
planer84122653_planer
rinser64317213rins__er
saber75330243__saber
safer84721813__safer
sager65432053__sager
saker95132023__saker
sander74828533__sander
sane45954343__sane_
saned65636273__saned
sanes55649073__sanes
sanger74524563__sanger
saver84831253__saver
sawer85026213__sawer
sayer84926553__sayer
sinner64320603sin__ner
sinsyne1043303sinsyne_
snarer64620843sn_arer
sneaker112910453sneaker
tinner64119963tin__ner
tisane6311573tisane_
tisanes7311853tisanes
uneager839753uneager
unmaker13279513unmaker
unsafe9310693unsafe_
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unsober967643unsober
urbaner9177133urbaner
vintager12104823vintager
vintner1034833vin_tner
weaner93816773_weaner
winner94219933win__ner
winsomer1345773winsomer

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.393454684.5
2DLD Change Limit1340272345.84322938.0
3Display Results2342340.0763078.9
 (SQL Overall)1786912346.31228309.7
 
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.