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

156 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
kaif11693393(None) 
kaf106845511ka_f
kaifs125715641kaifs
kail85131491kail
kain85334291kain
kalif125021361kalif
kif105941191k_if
naif76839021naif
waif105836751waif
aff95537612_aff
ai211288392_ai_
aid49269082_aid
ail37171042_ail
aim57858212_aim
ain37579092_ain
air38058392_air
ais39083572_ais
ait38093902_ait
akin86328032akin
alif76242142alif
arf67453372_arf
baff124632272baff
bail65042802bail
bait66556002bait
barf95844412barf
caff125631672caff
caid77837532caid
cain65643912cain
calf96339562calf
calif104929102calif
coif96337912coif
cuif96529142cuif
daff115229682daff
dais57040702dais
dif76846902_dif
fail74840242fail
fain75840562fain
fair76332522fair
gaff114828152gaff
gain56042162gain
gait56150192gait
haaf106227732haaf
haik115526982haik
hail74839062hail
hair76330142hair
half106238452half
if57239952__if
jail115529092jail
ka69145082ka__
kaas86531842kaas
kab97145852ka_b
kabs107130842kabs
kadi96224832kadi
kadis105921062kadis
kae76744542ka_e
kaes85734062kaes
kafir12488902kafir
kafs116423742kafs
kagu95418112kagu
kaiak8310352kaiak
kails95525212kails
kains96125642kains
kaka76518682kaka
kaki76520912kaki
kakis86116842kakis
kale86533752kale
kalifs134410982kalifs
kame105728232kame
kami105823642kami
kamik105011552kamik
kana85928532kana
kane85133972kane
kaon87521022kaon
kapa106021292kapa
kaph135815752kaph
karn86129412karn
kart86750802kart
kas77058582ka_s
kat77468292ka_t
kata85626022kata
kats85944332kats
kava115819702kava
kay106745542ka_y
kayo116417552kayo
kays116032192kays
keef115830002keef
kef105639662k_ef
keir86217872keir
kerf115827462kerf
khaf145319602khaf
khalif1657832khalif
khi106318302khi_
khis117017982khis
ki67537962k_i_
kid86540622k_id
kief117128412kief
kifs116023512k_ifs
kin76353972k_in
kip97042142k_ip
kir76535682k_ir
kis78051482k_is
kit78559882k_it
klik74412652klik
knife1210010132knife
knit85728142knit
koi77534752koi_
kois85129402kois
krait94726772krait
kris86423602kris
kufi11910652kufi
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
maid75537662maid
mail65543452mail
maim85831492maim
main65345522main
mair66133782mair
naff105128932naff
naifs87617422naifs
nail45838652nail
neif75429492neif
oaf65952882oa_f
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
qaid146023842qaid
raff104933042raff
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rain46251732rain
rais45252622rais
reif76937652reif
rif65951562_rif
said55742112said
sail45447162sail
sain45551292sain
seif75638732seif
tail45443652tail
tain45548072tain
vail75432552vail
vain75233002vain
vair75624142vair
waff134228042waff
waifs115719872waifs
wail75238822wail
wain75840202wain
wair75830052wair
wait75553692wait
yaff135324262yaff
zarf166929122zarf

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 Filter178691298720.283631417.0
2DLD Change Limit298721560.76339150.7
3Display Results1561560.0334727.3
 (SQL Overall)1786911561.079165608.0
 
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.