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

127 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
nabis7602058(None) 
nabes75427091nabes
nabs66236191nab_s
naris55735291naris
nazis145216081nazis
abas68642082_abas
abos67734412_abos
abris75722602_abris
abs59356072_ab_s
abys97221882_abys
ahis76135382_ahis
ais39083572_a_is
amis66445322_amis
anabas8314082anabas
anis45746462_anis
antis55033312antis
axis116127912_axis
babas96325732babas
babes95834112babes
babies106123652babies
babus95620332babus
basis75429862basis
bis56860662__bis
cabin94820942cabin
cabins104418922cabins
cabs86739422cab_s
cadis84428502cadis
dabs77139402dab_s
dais57040702da_is
fabs98635862fab_s
gabies93820732gabies
gabs76740422gab_s
gadis74825292gadis
habit103027022habit
habits113014652habits
habus106317142habus
hajis156716282hajis
ibis66519582_ibis
jabs135830092jab_s
kabs107130842kab_s
kadis105921062kadis
kakis86116842kakis
labia75219012labia
labs67145122lab_s
lapis76223152lapis
laris54737462laris
mabes96331532mabes
mavis105622722mavis
maxis145721562maxis
naans55815252naans
nab56954922nab__
nabe66029492nab_e
nabob93913742nabob
nabobs10388212nabobs
nadas66320812nadas
nadir61012972nadir
nadirs7109002nadirs
naffs116213962naffs
nags55436022na_gs
naif76839022na_if
naifs87617422naifs
nail45838652na_il
nails55730402nails
nalas55528362nalas
names74833362names
nanas55928632nanas
nanism8311202nanism
nans46139402na_ns
naoi46024632naoi_
naos47429732na_os
napas75924352napas
napes74828462napes
naps66238582na_ps
narcs76122022narcs
nards65928462nards
nares55544152nares
naric76824172naric
narks96026032narks
nates55238332nates
naves87030382naves
navies95218622navies
nays75931592na_ys
nazi136219872nazi_
nebs66124982neb_s
nibs65028312nib_s
nobs66436902nob_s
noris54928272noris
nubia7311232nubia
nubias8310092nubias
nubs65927142nub_s
oasis56422552oasis
obis66226842_obis
padis86227142padis
paris75145942paris
pavis106422732pavis
pubis94616472pubis
qadis155917852qadis
rabbis102613162rabbis
rabic93817402rabic
rabid84520782rabid
rabies85226022rabies
ragis66325602ragis
rais45252622ra_is
rakis95323442rakis
ranis55235832ranis
sabes76437462sabes
sabin74924952sabin
sabins85521982sabins
sabir75917002sabir
sabirs85414632sabirs
sabs66643742sab_s
sadis64930852sadis
sakis95323672sakis
saris54544952saris
satis55633682satis
tabbis102910862tabbis
tabes76033922tabes
tabid84418262tabid
tabs66842982tab_s
tabus74820922tabus
tamis76728732tamis
tapis75028862tapis
taxis126821972taxis
unais53420772una_is
wabs97337232wab_s
wadis95223962wadis
yagis95416572yagis

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 Filter178691538000.310576422.6
2DLD Change Limit538001271.53335094.6
3Display Results1271270.0304233.3
 (SQL Overall)1786911271.87395403.6
 
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.