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

190 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
insults726896(None) 
indults8289491indults
insult62813671insult_
consults10219982consults
incult82414772incult_
inducts10259572inducts
indult73614032indult_
ingulfs1134732ingulfs
inputs837702inpu_ts
insculps1243392insculps
insects93710842insects
inserts74013992inserts
insets64016132ins_ets
insists739082insists
insoles73516242insoles
insouls737212insoul_s
insulants946912insulants
insular7138702insular
insulars8137322insulars
insulate8312842insulate
insulates9311842insulates
insulin738482insulin
insulins848862insulins
insulted937192insulted
insulter836882insulter
insulters945882insulters
insures73117262insures
intuits7310312intuits
results739832results
adults7299953_adults
ainsells895403ainsells
annulets845813annulets
annuls64711733annul_s
annulus7426613annulus
assaults843863assaults
basalts9358963basalts
consuls92412313consul_s
consult92513633consult_
cults75022553__cults
desalts839573desalts
engluts834533engluts
engulfs1143833engulfs
ensiles72714833ensiles
ensouls736033ensoul_s
ensues63313813ensu_es
ensures73315903ensures
exults13257633_exults
faults94513553_faults
gaults74112783_gaults
inbuilt947323inbuilt_
inburst937163inburst
inbursts1044323inbursts
incants92012803incants
incents92414533incents
incepts11238283incepts
incests92711383incests
incrusts1036253incrusts
incubus1144743incubus
incudes10319523incudes
incurs83012283incu_rs
incus73315053incu__s
incuses93514853incuses
indents83114663indents
indicts103210723indicts
indoles83716363indoles
indols74714203indol_s
induces103611813induces
induct93212743induct_
indues73515263indu_es
indulge945403indulge
indulges1045263indulges
indulin838773indulin
indulins958863indulins
inerts64517023in_erts
infalls1038943infalls
infants102210773infants
infects12279713infects
infests10279793infests
infolds11137023infolds
infuses102711873infuses
ingests83210983ingests
ingles74420873in_gles
ingots7912063in_gots
ingulf10310353ingul_f
inhales10511863inhales
inhauls1035523inhaul_s
inhumes1296883inhumes
injects16257453injects
injures143111173injures
inkblots1442663inkblots
inkles103515653in_kles
inkpots1335173inkpots
inlets63915573in_lets
input7314653inpu_t_
inquest1638603inquest
inquests1744943inquests
inquiets1745433inquiets
inruns6359513inru_ns
insculp1143793inscul_p
inseams9307903inseams
insect83916583insect_
insert64325253insert_
inset54430863ins_et_
insides8512653insides
insights1245493insights
insist6314513insist_
insolate8311893insolate
insolates9311273insolates
insole63515863insol_e
insolents9137523insolents
insoul638463insoul__
insouled936113insouled
inspans937803inspans
inspects1255863inspects
installs858923installs
instals7611713instals
instants8910153instants
instars7411133instars
instate71616483instate
instates81615833instates
insteps936573insteps
instills867353instills
instils7811453instils
instructs1145793instructs
insulant849883insulant
insulated10310713insulated
insulator948103insulator
insulators1047263insulators
insulting1038053insulting
insurants947653insurants
insure63416603insu_re
insured83714253insured
insureds9277613insureds
insurer73312803insurer
insurers83710133insurers
intents72115703intents
intorts7310973intorts
intrusts837723intrusts
intuit6314083intuit_
inturns73210133inturns
inulase739413in_ulase
inulin6311733in_ulin
inulins7311493in_ulins
inures63318953in_ures
inurns63310983in_urns
invents102812053invents
inverts103211953inverts
invests10319683invests
inwalls1037283inwalls
irrupts943733irrupts
isles54220563i_s_les
islets64513083i_slets
issuers746123issuers
issues648803issu_es
istles62814983i_stles
jesuits1436323jesuits
knouts10438313knou_ts
midcults1343223midcults
minuets9259853min_uets
missuits1078023missuits
moults84713703_moults
nisus56014393nisu__s
nonsuits869153nonsuits
nulls55019983_n_ulls
nuts45032673_n_u_ts
occults1135123occults
onsets64013543ons_ets
penults937123penults
pinnules1036463pinnules
poults84613483_poults
result6318223result_
salts55431883__salts
saults65816173_saults
silts55330823__silts
sluts54523983__sluts
snouts64915873snou_ts
suets55126103__suets
suits55028053__suits
sulks94818463__sulks
sulus54821883__sulus
sunsuits845963sunsuits
tinfuls1036593tinful_s
tinsels738373tinsel_s
tumults934823tumults
unbelts9237663unbelts
unbolts9247803unbolts
unseats73012853unseats
unsells73210773unsells
unsets64116163uns_ets
vaults94511673_vaults

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 Limit1340271905.98622390.1
3Display Results1901900.0633015.9
 (SQL Overall)1786911906.45527682.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.