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

272 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
insurer7331280(None) 
ensurer73011901ensurer
injurer14318471injurer
insure63416601insure_
insured83714251insured
insurers83710131insurers
insures73117261insures
assurer767792assurer
censurer10228132censurer
coinsurer1144772coinsurer
endurer83210362endurer
ensure63416002ensure_
ensured83512942ensured
ensurers8279372ensurers
ensures73315902ensures
impurer1136482impurer
inducer10318762inducer
infuser10298322infuser
inhumer1275382inhumer
injure133410862injure_
injured15339062injured
injurers15286122injurers
injures143111172injures
inquirer17235172inquirer
insaner7310442insaner
inserter82312132inserter
insider849732insider
insnarer865302insnarer
inspirer1045182inspirer
insular7138702insular
insulter836882insulter
insureds9277612insureds
inure54119052in_ure_
inured73114812in_ured
inures63318952in_ures
issuer646622issu_er
reinsurer945602reinsurer
surer54833102__surer
unsure62815412unsure_
usurer638102_usurer
abjurer1634753abjurer
absurder11134363absurder
adjurer1534823adjurer
allurer7348433allurer
answer936893ans_wer
answerer1144273answerer
assumer965363assumer
assure6610773assure_
assured858373assured
assurers866313assurers
assures7611403assures
assuror754203assuror
augurer8136343augurer
censure92310603censure_
censured11248913censured
censurers11256073censurers
censures102211623censures
coinsure1046933coinsure_
coinsured1245513coinsured
coinsurers1243933coinsurers
coinsures1136723coinsures
conjurer17117683conjurer
consumer1238503consumer
curer75030753__curer
demurer1037873demurer
desirer8310783desirer
dourer74215273_dourer
endure74014143endure_
endured93611213endured
endurers9317953endurers
endures83314603endures
ensnarer874473ensnarer
ensue54013833ensu_e_
ensued73610483ensu_ed
ensues63313813ensu_es
enterer72015633enterer
enure53520223en_ure_
enured73315333en_ured
enures63919713en_ures
figurer11215863figurer
fingerer12127223fingerer
fissure1036783fissure_
fissured1235183fissured
fissures1136573fissures
gesturer935983gesturer
hinderer1238273hinderer
honourer1146243honourer
ignorer8276103ignorer
immure1036033immure_
immured1235063immured
immures1136713immures
impure1038383impure_
imputer1136533imputer
inaner62213543in_aner
inbred93010403in_bred
inburst937163inburst
incher114114033in_cher
incisure1044563incisure_
incisures1144513incisures
inciter93113773inciter
incomer1169943incomer
incudes10319523incudes
incumber1444553incumber
incur72212253incu__r
incurred1136493incurred
incurs83012283incur_s
incurve1236633incurve
incurved1435313incurved
incurves1336393incurves
incuse83513573incuse_
incused102911173incused
incuses93514853incuses
indexer15287253indexer
inditer83514233inditer
indorser985713indorser
induce93811533induce_
induced11298933induced
inducers11326953inducers
induces103611813induces
indue63516673indu_e_
indued83411653indu_ed
indues73515263indu_es
indulger1044153indulger
infare9313083infare_
infares10313023infares
infer84215033in__fer
inferrer11217443inferrer
informer13227283informer
infuse93110573infuse_
infused11329253infused
infusers11286143infusers
infuses102711873infuses
inhaler1068053inhaler
inhauler1163943inhauler
inhere9313713inhere_
inhered11313163inhered
inheres10315173inheres
inhume1196583inhume_
inhumed1375573inhumed
inhumers1364823inhumers
inhumes1296883inhumes
injuries1567683injuries
injury16266143injur_y
inker94421093in__ker
inkier104013783in_kier
inlayer1036933inlayer
inlier63615363in_lier
inner54920633in__ner
inpoured1135813inpoured
inputter1034203inputter
inquiet16311413inquiet
inquire16227993inquire_
inquired18245933inquired
inquirers18234013inquirers
inquires17237363inquires
insane6314893insane_
inscriber1343863inscriber
insecure1044653insecure_
insert64325253inser_t
inserted92413053inserted
inserters92210283inserters
inserts74013993inserts
inset54430863ins__et
insetter8218593insetter
inshore1038723inshore_
inside7613453inside_
insiders947763insiders
insides8512653insides
insister888783insister
insnare748243insnare_
insnared956123insnared
insnarers954433insnarers
insnares858083insnares
insofar1043543insofar
insole63515863insole_
insoles73516243insoles
insouled936113insouled
insphere1355973insphere
inspire938253inspire_
inspired1136273inspired
inspirers1143963inspirers
inspires1037623inspires
instar6310013ins_tar
instep838193ins_tep
insulars8137323insulars
insulin738483insulin
insult62813673insu_lt
insulted937193insulted
insulters945883insulters
insults7268963insults
insurant8411423insurant
insurgent1046543insurgent
insuring9311153insuring
integer837993integer
inter55028493in__ter
intoner7811673intoner
intruder945213intruder
inturn63411563intur_n
inturned9268313inturned
inturns73210133inturns
inurn53712863in_ur_n
inurned8328053in_urned
inurns63310983in_urns
invader11146453invader
inverter112411073inverter
inviter104112313inviter
invoker1435363invoker
isomer8310153i_somer
issue559213issu_e_
issued746723issu_ed
issuers746123issuers
issues648803issu_es
lingerer9118303lingerer
lurer54625313__lurer
manurer938583manurer
maturer938973maturer
measurer1035953measurer
minster93914323mins_ter
minstrel1046913minstrel
minuter93510413min_uter
misuser93210443misuser
nearer64618893_nearer
neuter63713793_neuter
nuder66416833_n_uder
nurser64314503_n_urser
obscurer1243523obscurer
pasturer1037523pasturer
pinscher1544803pinscher
posturer1038923posturer
pourer84516043_pourer
purer75127903__purer
rasure6311423rasure_
rasures7312013rasures
reinsure837913reinsure_
reinsured1036983reinsured
reinsurers1043573reinsurers
reinsures937963reinsures
resumer9410113resumer
rinser64317213rins__er
scourer93910433scourer
securer958253securer
serer55935513__serer
sincerer1037203sincerer
snarer64620843sn_arer
sneerer73512313sneerer
snorer64316763sn_orer
sorer56236593__sorer
sourer63620213_sourer
suber74924503__suber
suer45334033__su_er
super74924483__super
sure45447413__sure_
surfer93515883__surfer
surger74320093__surger
tinkerer1286803tinkerer
tonsure758783tonsure_
tonsured976383tonsured
tonsures869133tonsures
tourer64115073_tourer
uncured10513233uncured
uninsured1044873uninsured
unpure82911533unpure_
unscrew1245463unscrew
unsober967643unsober
unsoured9310063unsoured
unsurely1146383unsurely
untruer737113untruer
usurers766363_usurers
usurper934353_usurper
venturer1137243venturer
winsomer1345773winsomer
winterer112110443winterer

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.423422437.4
2DLD Change Limit1340272726.45320769.7
3Display Results2722720.1102472.7
 (SQL Overall)1786912726.98625578.4
 
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.