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

130 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
kakis8611684(None) 
kadis105921061kadis
kakas85117341kakas
kaki76520911kaki_
khakis1265851khakis
rakis95323441rakis
sakis95323661sakis
ahis76135382_ahis
ais39083572_a_is
akin86328032_akin
amis66445312_amis
anis45746462_anis
axis116127912_axis
bakes117035372bakes
basis75429862basis
cadis84428492cadis
cakes116037672cakes
dais57040702da_is
daks97130602dak_s
fakes126032482fakes
fakir125111492fakir
fakirs13468082fakirs
gadis74825292gadis
haiks125120932haiks
hajis156716272hajis
hakes126034302hakes
hakim14311822hakim
hakims1537302hakims
hakus125114112hakus
jakes165023642jakes
kaas86531842ka_as
kabikis1243862kabikis
kabs107130842ka_bs
kabukis1243192kabukis
kadi96224822kadi_
kaes85734062ka_es
kafir12488902kafir
kafirs13306982kafirs
kafs116423742ka_fs
kagus105812032kagus
kaif116933922ka_if
kaifs125715642kaifs
kail85131492ka_il
kails95525212kails
kain85334292ka_in
kains96125642kains
kaka76518682kak_a
kales95730982kales
kalif125021352kalif
kalifs134410982kalifs
kames115024692kames
kami105823642kami_
kamik105011552kamik
kamiks11387912kamiks
kanas95326912kanas
kanes95529372kanes
kanjis1735962kanjis
kaons95014852kaons
kapas116021732kapas
kaphs144911502kaphs
karns96624142karns
karts97630112karts
kas77058582ka__s
katas95922092katas
kats85944332ka_ts
kauris103611522kauris
kavas125919952kavas
kayos127714702kayos
kays116032192ka_ys
kepis115313362kepis
khadis1446912khadis
khaki1157642khaki_
khis117017982k_his
kikes85122552kikes
kis78051472__kis
kiwis12328582kiwis
kliks8398822kliks
kois85129392k_ois
kojis16468432kojis
kris86423602k_ris
kufis1249252kufis
kukris934452kukris
kyaks11459162kyak_s
lakes95737652lakes
lakhs125210342lakhs
lapis76223152lapis
laris54737462laris
makes115336852makes
makos116518362makos
mavis105622722mavis
maxis145721562maxis
nabis76020572nabis
naris55735292naris
nazis145216082nazis
oaks86527902oak_s
oasis56422552oasis
okapis1235392okapis
padis86227142padis
paiks114719852paiks
paris75145942paris
pavis106422732pavis
pikis115116392pikis
qadis155917852qadis
ragis66325602ragis
rais45252622ra_is
rakes94440352rakes
raki87127832raki_
rakish134313962rakish
rakus94413672rakus
ranis55235832ranis
sadis64930852sadis
sakes95540752sakes
saki85628472saki_
saris54544952saris
satis55633672satis
skis84825282_skis
takas95520682takas
takes94437792takes
takin94921302takin
takins105117402takins
tamis76728722tamis
tapis75028862tapis
taxis126821972taxis
tikis95615972tikis
vakil1259792vakil
vakils1337592vakils
wadis95223962wadis
wakes126633652wakes
yagis95416572yagis
yaks116025202yak_s

Search took 5 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.313570897.8
2DLD Change Limit538001303.87313891.0
3Display Results1301300.0632063.5
 (SQL Overall)1786911304.24942054.8
 
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.