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 “kivas” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
kivas12461473(None) 
divas95418581divas
kavas125919951kavas
kinas95626911kinas
kiva116516401kiva_
kvas117015941k_vas
vivas114815021vivas
ajivas1655132ajivas
bias64738152bi_as
bimas95521742bimas
devas96218882devas
ditas65923672ditas
diva85920882diva_
divan96114842divan
divans104612392divans
dives95832402dives
favas115618592favas
fives116027362fives
gigas75415582gigas
gives95324872gives
hives116925512hives
javas155915422javas
jives154820812jives
kaas86531842k_aas
kakas85117342kakas
kanas95326912kanas
kapas116021732kapas
kas77058582k__as
katas95922092katas
kava115819702kava_
kavass13517302kavass
keas86337092k_eas
kibes115521112kibes
kiblas1239322kiblas
kicks104420082kicks
kids96029632ki_ds
kiefs126112202kiefs
kiers95320092kiers
kifs116023502ki_fs
kikes85122552kikes
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
kina85631992kina_
kinase104210652kinase
kinds106221812kinds
kines95039132kines
kings105825562kings
kinks84926082kinks
kinos96626142kinos
kins85747902ki_ns
kips106430512ki_ps
kirks84915262kirks
kirns95315452kirns
kirs85831732ki_rs
kis78051472ki__s
kiss85227392ki_ss
kists95822112kists
kites95432542kites
kiths125814972kiths
kits86441762ki_ts
kiwis12328582kiwis
knives13458552knives
koas85635092k_oas
kolas94822232kolas
koras95927112koras
kuvasz2242232kuvasz
kvass12507272k_vass
lavas85422222lavas
limas75627632limas
liras56021982liras
litas54923772litas
lives86133192lives
micas96823052micas
minas75434112minas
nipas77116672nipas
nival84915772nival
novas85215362novas
pias66542552pi_as
picas94626522picas
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pitas77427672pitas
rias45540592ri_as
rival85216502rival
rivals94213182rivals
rives85336002rives
shivas124512412shivas
sikas94617022sikas
silvas92912182silvas
simas75727552simas
skives134113942skives
ulvas84511502ulvas
vas67755772__vas
vigas94817882vigas
vinas85126342vinas
visas84317652visas
viva106119092viva_
wives115328922wives

Search took 2 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 Filter178691538000.1401276364.3
2DLD Change Limit538001011.79629955.5
3Display Results1011010.0166312.5
 (SQL Overall)1786911011.95291542.5
 
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.