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

139 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
insouls73721(None) 
ensouls736031ensouls
insoul638461insoul_
ensoul638252ensoul_
indols74714202indo_ls
inhauls1035512inhauls
inpours936412inpours
insculp1143792insculp
insculps1243392insculps
insole63515862inso_le
insoles73516242insoles
insouled936112insouled
instals7611712instals
instils7811452instils
insult62813672ins_ult
insults7268962ins_ults
souls55127362__souls
ainsells895403ainsells
annuls64711733an_nuls
assoils776663assoils
befouls1236053befouls
cineols9128853cineo_ls
consols92914073conso_ls
consuls92412313cons_uls
enols54718403en_o_ls
enrolls7108093enrolls
enrols61213383enro_ls
ensouled935833ensouled
ensues63313813ens_ues
entoils7810733entoils
fouls87221433__fouls
ghouls1036043_ghouls
idols65514133i_do_ls
igneous835773igneou_s
inbound10115773inbound
inbounds11134053inbounds
incogs937903inco_gs
incomes11712373incomes
incult82414773in_cult
incurs83012273in_curs
incus73315053in_cu_s
indiums1037143indiums
indol63714873indo_l_
indole74516053indo_le
indoles83716363indoles
indoors838553indoors
indows104210793indo_ws
indoxyls1942253indoxyls
indues73515263in_dues
indult73614033in_dult
indults8289493in_dults
infalls1038943infalls
infold10128163info_ld
infolds11137023infolds
informs1248063informs
infos84311673info__s
ingots7912063ingo_ts
ingroups1143483ingroups
ingulf10310353in_gulf
ingulfs1134733in_gulfs
inhaul936803inhaul_
inions64417003inio_ns
inocula947253inocula
inpour837063inpou_r
inputs837703in_puts
inroads837043inroads
inruns6359513in_runs
inscrolls11112483inscrolls
inseams9307903inseams
insects93710843insects
inserts74013993inserts
insets64016133ins_ets
insides8512653insides
insists739083insists
insofar1043543insofar
insoluble1144243insoluble
insolubles1253013insolubles
insolubly1443653insolubly
insomuch1581993insomuch
insouling1036823insouling
inspans937803inspans
instal6712183instal_
install779353install
installs858923installs
instars7411113instars
insteps936573insteps
instil61111383instil_
instill789063instill
instills867353instills
insular7138703ins_ular
insulars8137323ins_ulars
insulin738483ins_ulin
insulins848863ins_ulins
insure63416603ins_ure
insures73117263insures
intombs1144153intombs
intones7816543intones
intorts7310963intorts
invokes1436383invokes
inwalls1037283inwalls
inwound11134973inwound
iodous7311493iodou_s
isohels1035393i_sohels
issues648803i_ssues
knolls10367413kn_olls
knouts10438313kn_outs
lintols7339553linto_ls
missouts1037623missouts
nicols8810243nico_ls
nisus56014393nis_u_s
noels56418703_n_oels
noils55024333_n_oils
nouns56717313_n_ouns
nous46136983_n_ou_s
sauls55128123__sauls
shuls85319713__shuls
sinuous739063sinuou_s
snools65715873sn_ools
snouts64915863sn_outs
soils55327983__soils
sols45448163__so_ls
solus54726983__solus
souks94820523__souks
soul46435713__soul_
soups75322943__soups
sours55230503__sours
sous46947213__sou_s
tinfoils1144323tinfoils
tinfuls1036593tin_fuls
tinsels738373tins_els
uncoils979533uncoils
unrolls797793unrolls
unseals73212573unseals
unsells73210773unsells
unsold71410513unso_ld
unsound8158433unsound
unspools1043693unspools
vinous93914173vin_ou_s
zincous1837053zincou_s

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.1531167915.0
2DLD Change Limit1340271396.45620760.1
3Display Results1391390.0433232.6
 (SQL Overall)1786911396.65226862.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.