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

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
kaifs12571564(None) 
kafs116423741ka_fs
kaif116933931kaif_
kails95525211kails
kains96125641kains
kalifs134410981kalifs
kifs116023501k_ifs
naifs87617421naifs
waifs115719871waifs
aids57846352_aids
ails45654712_ails
aims67738182_aims
ains46158882_ains
airs46447422_airs
ais39083572_ai_s
aits46355532_aits
alifs86121262alifs
arfs76029962_arfs
baffs134718052baffs
bails75933522bails
baits76630582baits
barfs104826002barfs
caffs135417372caffs
caids85226422caids
cains75334302cains
calfs104919382calfs
califs114915892califs
coifs105718702coifs
cuifs104814692cuifs
daffs125116422daffs
dais57040702dai_s
difs86027322_difs
fails85631482fails
fairs85825442fairs
gaffs124914652gaffs
gains65729512gains
gaits65726012gaits
haafs115711162haafs
haiks125120932haiks
hails85231642hails
hairs86225172hairs
ifs67124242__ifs
jails125422942jails
kaas86531842ka_as
kabs107130842ka_bs
kadis105921062kadis
kaes85734062ka_es
kaf106845512ka_f_
kafir12488902kafir
kafirs13306982kafirs
kagus105812032kagus
kaiak8310352kaiak
kaiaks937042kaiaks
kail85131492kai_l
kain85334292kai_n
kakas85117342kakas
kakis86116842kakis
kales95730982kales
kalif125021362kalif_
kames115024692kames
kamiks11387912kamiks
kanas95326912kanas
kanes95529372kanes
kaons95014852kaons
kapas116021732kapas
kaphs144911502kaphs
karns96624142karns
karts97630112karts
kas77058582ka__s
katas95922092katas
kats85944332ka_ts
kavas125919952kavas
kayos127714702kayos
kays116032192ka_ys
keefs125116282keefs
kefs115922742k_efs
keirs95313672keirs
kerfs125413572kerfs
khafs15648842khafs
khalifs1754072khalifs
khis117017982khi_s
kids96029632k_ids
kiefs126112202kiefs
kif105941182k_if_
kins85747902k_ins
kips106430512k_ips
kirs85831732k_irs
kis78051472k_i_s
kiss85227392k_iss
kits86441762k_its
kliks8398822kliks
knife1210010132knife
knifes136210212knifes
knits93914742knits
kois85129392koi_s
kraits104912202kraits
kris86423602kri_s
kufis1249252kufis
laics76419252laics
lairs55425872lairs
maids86327142maids
mails76037782mails
maims96321792maims
mains75635102mains
mairs76228302mairs
naffs116213962naffs
naif76839022naif_
nails55730402nails
neifs85613042neifs
oafs76425262oa_fs
paiks114719852paiks
pails75833062pails
pains75138282pains
pairs75325832pairs
qaids156116312qaids
raffs115017522raffs
raias54631122raias
raids65827512raids
rails55937402rails
rains55140232rains
rais45252622rai_s
reifs84819092reifs
rifs74929002_rifs
saids65328852saids
sails55738102sails
sains55639972sains
seifs85019332seifs
tails55634192tails
tains54936322tains
vails85825932vails
vairs85019132vairs
waffs146315472waffs
waif105836752waif_
wails86631482wails
wains86930862wains
wairs86424062wairs
waits88333522waits
yaffs145311122yaffs
zarfs174713622zarfs

Search took 3 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.0931921408.6
2DLD Change Limit538001391.87628678.0
3Display Results1391390.0463021.7
 (SQL Overall)1786911392.01588680.4
 
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.