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

196 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
kaffir1634530(None) 
kaffirs17325551kaffirs
kafir12488901ka_fir
zaffir21395511zaffir
affair1234352_affair
affirm1435522_affirm
affix1836002_affix
daffier1457832daffier
gaffer134310132gaffer
haffit1538532haffit
kafirs13306982ka_firs
kefir12457912k_efir
maffia14327202maffia
maftir1136492maftir
raffia12287702raffia
taffia12286902taffia
waffie15338562waffie
zaffar21385042zaffar
zaffer21397152zaffer
zaffirs22375662zaffirs
afar76720783_a_far
aff95537613_aff__
affaire1344463_affaire
affairs1334163_affairs
affine12310503_affine
affirms1534383_affirms
affixer2033913_affixer
afford1346493_afford
afire86215913_a_fire
afrit8323173_afrit
after85719793_after
air38058393_a__ir
amir65129753_a_mir
astir55517093_astir
baff124632273baff__
baffed154812173baffed
baffies153612943baffies
baffing164011603baffing
baffle14399873baffle
baffler15418113baffler
baffs134718053baff_s
baffy165511923baff_y
biffin14369103biffin
boffin14359053boffin
buffer144512683buffer
buffi136112203buffi_
buffier1568403buffier
caff125631673caff__
caffein1535333caffein
caffs135417373caff_s
chaffer18389473chaffer
chaffier1935473chaffier
coffer144112863coffer
coffin14339813coffin
daff115229683daff__
daffed14429493daffed
daffily1735143daffily
daffing15369733daffing
daffs125116423daff_s
daffy155510283daff_y
dafter104813343dafter
deffer134411303deffer
differ133910843differ
doffer133911353doffer
draffier1574323draffier
duffer134711663duffer
fair76332523__fair
fakir125111493fa_kir
fanfic1436313fanfic
faqir17548643fa_qir
faquir1834313faquir
fir66744893___fir
flir76422203__flir
gaff114828153gaff__
gaffe124111653gaff_e
gaffed144210203gaffed
gaffers14428713gaffers
gaffes134811103gaffes
gaffing15379733gaffing
gaffs124914653gaff_s
gambir11509773gambir
gauffer1474423gauffer
goffer13409513goffer
haffet15311703haffet
haffits1636193haffits
hafiz20611213ha_fiz
hafter124815883hafter
hair76330143ha__ir
huffier1637493huffier
iffier1236763_iffier
kabar114815553ka_bar
kadi96224833ka_di_
kadis105921063ka_dis
kaf106845513ka_f__
kaffiyah2491573kaffiyah
kaffiyeh2461923kaffiyeh
kafs116423743ka_f_s
kaftan13185823kaftan
kaif116933933ka__if
kaifs125715643kaif_s
kail85131493ka__il
kain85334293ka__in
kainit10414483kainit
kaiser103610373kaiser
kaki76520913ka_ki_
kakis86116843ka_kis
kalif125021363ka_lif
kalifs134410983kalifs
kalmia1238893kalmia
kami105823643ka_mi_
kamik105011553ka_mik
kamsin1238323kamsin
kanji1647453kanji_
kanjis1735963kanjis
kantar10311153kantar
kaolin1039583kaolin
kaonic1238763kaonic
karmic1438113karmic
kasher134915033kasher
kashmir16162403kashmir
kauri93811853kauri_
kauris103611533kauris
kefirs13396653k_efirs
keir86217873k__eir
kir76535683k___ir
knifer13598563knifer
kufi11910653k_ufi_
kufis1249253k_ufis
lair45934153la__ir
maffias15327283maffias
maffick2143523maffick
mafia104418033ma_fia
mafic125615463ma_fic
maftirs1236043maftirs
mair66133783ma__ir
miffier1537023miffier
muffin14298873muffin
nadir61012973na_dir
naff105128933naff__
naffed13408333naffed
naffing14359033naffing
naffs116213963naff_s
niffer12378443niffer
offer114311383_offer
pair66031513pa__ir
piaffer15104443piaffer
puffer144610733puffer
puffier1547973puffier
puffin141149003puffin
quaffer2235133quaffer
raff104933043raff__
raffias13237713raffias
raffish1658843raffish
raffle123910703raffle
raffler13339223raffler
raffs115017523raff_s
rafter94517583rafter
reaffirm1642483reaffirm
reaffix2042323reaffix
sabir75917003sa_bir
safari91110223safari
safer84721813sa_fer
santir6315253santir
soffit1237883soffit
staffer13299093staffer
suffer124314513suffer
suffix1935233suffix
taffias13377413taffias
taffies133012693taffies
taffy145110823taff_y
tafia84215493ta_fia
tapir75917063ta_pir
tiffin12327933tiffin
traffic1544733traffic
unfair936233unfair
vair75624143va__ir
wafer114417643wa_fer
waff134228043waff__
waffed16459793waffed
waffies163611443waffies
waffing173710243waffing
waffle15369183waffle
waffler16377783waffler
wafflier1733953wafflier
waffly18305433waffly
waffs146315473waff_s
wafter124114613wafter
wair75830053wa__ir
yaff135324263yaff__
yaffed16457323yaffed
yaffing17337823yaffing
yaffs145311123yaff_s
zaffars22325233zaffars
zaffers22386773zaffers
zaffre21354663zaffre
zaftig1933253zaftig

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161965.59320153.0
3Display Results1961960.0633111.1
 (SQL Overall)1786911966.04629555.2
 
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.