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

154 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
naif7683902(None) 
kaif116933931kaif
naff105128931naff
naifs87617421naifs
nail45838651nail
neif75429491neif
waif105836751waif
aff95537612_aff
ai211288392_ai_
aid49269072_aid
ail37171042_ail
aim57858212_aim
ain37579092_ain
air38058392_air
ais39083572_ais
ait38093902_ait
alif76242142alif
ani37751182ani_
anil46437432anil
anis45746462anis
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
kaf106845512ka_f
kaifs125715642kaifs
kail85131492kail
kain85334292kain
kalif125021362kalif
kif105941182_kif
laic65931562laic
laid56439142laid
lain46146282lain
lair45934152lair
maid75537662maid
mail65543452mail
maim85831492maim
main65345522main
mair66133782mair
na28652482na__
naan47621932naan
nab56954922na_b
nabe66029492nabe
nabis76020582nabis
nabs66236192nabs
nada58022902nada
nadir61012972nadir
nae35952742na_e
naffs116213962naffs
nag46450812na_g
nags55436022nags
nah69847002na_h
naiad6313402naiad
nails55730402nails
naira5314742naira
nairu5413812nairu
naive85116212naive
nakfa1236092nakfa
nala46930392nala
nam55953392na_m
name65637412name
nan37854882na_n
nana46632902nana
nans46139402nans
naoi46024632naoi
naos47429732naos
nap56753202na_p
napa66927262napa
nape65230802nape
naps66238582naps
narc67127952narc
nard56634452nard
naric76824172naric
naris55735292naris
nark85230062nark
nary76931222nary
nave75732312nave
navy107518632navy
naw66346492na_w
nay66952772na_y
nays75931592nays
nazi136219872nazi
nazify2134232nazify
nazis145216082nazis
neifs85613042neifs
nib56745192n_ib
nil36144192n_il
nim57142952n_im
nip56945982n_ip
nit37065942n_it
nix106932832n_ix
noil46133242noil
noir46722432noir
oaf65952882oa_f
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
qaid146023842qaid
raff104933042raff
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rain46251732rain
rais45252622rais
reif76937652reif
rif65951562_rif
said55742112said
sail45447162sail
sain45551292sain
seif75638732seif
snail57020202snail
snarf86525422snarf
tail45443652tail
tain45548072tain
unai44824782unai_
unais53420772unais
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.296603685.8
2DLD Change Limit298721540.89333451.3
3Display Results1541540.0463347.8
 (SQL Overall)1786911541.235144689.1
 
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.