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

207 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
nudists835683(None) 
nudisms10305851nudisms
nudist73813321nudist_
audits72814112audi_ts
aurists74615782aurists
autists73814852autists
bundists1145382bundists
cubists11359022cubists
feudists1244462feudists
judoists1643652judoists
jurists14409122jurists
lutists73810272lutists
nudest74113832nudest_
nudies75217092nudi_es
nudism9357912nudis_m
nudity1037992nudi_ty
odists749852_odists
purists94014072purists
sadists83310852sadists
tubists9288322tubists
addicts1176013addicts
adits66523713_adi_ts
ageists848493ageists
agists75713173_agists
animists103010633animists
aorists74215823aorists
artists74215583artists
assists738473assists
audients946353audients
audiles83112613audiles
audings9289393audings
audios72312283audi_os
audit62527883audi_t_
aurist65027253aurist_
autisms94311553autisms
autist64324943autist_
bedsits1037563bedsits
bemists113410703bemists
budgets11489863budgets
bundist10310193bundist_
bursts85116243bu_rsts
busts75227693bu__sts
chutists1335583chutists
cists76624533__cists
cladists1136713cladists
cubisms13306883cubisms
cubist104214443cubist_
cubits103714033cubi_ts
cultists10107633cultists
cutises94414913cutises
dadaists1045583dadaists
deists74916433_deists
delists84414173delists
desists83611723desists
diets66026643__diets
dints67431313__dints
dirts66824463__dirts
discs85316263__discs
disks105417473__disks
diss56434483__dis_s
dits56450523__di_ts
dualists958243dualists
dudish1148313dudis_h
duelists966003duelists
duits65021883du_i_ts
dusts65923563__dusts
edicts94911703_edicts
edits65819033_edi_ts
egoists887073egoists
enlists749393enlists
entwists1156143entwists
exists134710913_exists
faddists13235543faddists
fauvists1443843fauvists
feists94915313_feists
feudist1137573feudist_
fideists1245543fideists
fists85527543__fists
flutists11256413flutists
foists95413983_foists
fuguists1243693fuguists
gists66026193__gists
gnomists1145473gnomists
grists74716483_grists
guests74311203gu_ests
guilts74111233gu_ilts
guises74216313gu_ises
gusts65722793gu__sts
heists96814633_heists
hists86328373__hists
hoists95516023_hoists
holists104413963holists
hursts97213093hu_rsts
idiots768643_idiots
indicts103210723indicts
insists739083insists
intwists1145593intwists
iodises83413633iodises
iodisms10308483iodisms
joists134711033_joists
judases1534443judases
judoist1545633judoist_
jujuists1442273jujuists
jurist134616393jurist_
justs124918263ju__sts
kists95822113__kists
kumiss1235923kumis_s
legists899593legists
lists56628693__lists
lusts55022803lu__sts
lutist64317553lutist_
lyrists1036963lyrists
maists85817573_maists
midlists1137523midlists
midsts95510053mid_sts
mists76633903__mists
modiste1039283modiste
modistes1138643modistes
monists93614783monists
monodists1247703monodists
mudcats1236223mudcats
musts75527443mu__sts
mutisms11338453mutisms
nadirs7109003nadi_rs
nanisms938833nanisms
narcists1078113narcists
naturists947503naturists
neist54628443n_eist_
nests55728003n__ests
nidgets9358143nidgets
niduses837013niduses
nisus56014393n__isus
nits45741643n__i_ts
noises65021853n_oises
nomisms11268743nomisms
nubias8310093nubi_as
nudes64723293nud__es
nudgers9479373nudgers
nudges84114733nud_ges
nudie65118673nudi__e
nudities939683nudities
nudnicks1542403nudnicks
nudniks1262333nudniks
nudzhes2032523nudzhes
nuggets936383nuggets
numbats1137673numbats
nurses63919353nu_rses
nutlets74111253nutlets
nuts45032673nu___ts
oboists937903oboists
oculists1037133oculists
odist6421913_odist_
onanists838413onanists
ousts55225703ou__sts
outsits73215253outsits
papists112110453papists
pundits10379293pundi_ts
purisms114110833purisms
purist85525053purist_
qubits173710353qubi_ts
querists1736543querists
quests153310353qu_ests
quiets154014373qu_iets
quilts154112543qu_ilts
quints154316563qu_ints
quirts154213553qu_irts
quits144122353qu_i_ts
quoits15379683quoi_ts
racists92613323racists
rapists92510743rapists
relists73817053relists
resists74414923resists
rudest74016313rudest_
rusts55026993ru__sts
sadisms10359113sadisms
sadist74221353sadist_
schists1248543schists
sexists14267673sexists
shists96515103_shists
subsists1037993subsists
sudses74114503sud_ses
suints64617783su_ints
suits55028053su_i_ts
sumoists1046733sumoists
tanists7313653tanists
theists1039143theists
tourists838313tourists
tubaists1055093tubaists
tubist83013163tubist_
turista737443turista
turistas846693turistas
twists9549753_twists
typists1236173typists
undies73821963undi_es
undines8716083undines
unfits93910293unfi_ts
units54923433_uni_ts
unrests7229463unrests
untwists1144623untwists
unwits9389893unwi_ts
verists103613673verists
vibists1256483vibists
waists97415453_waists
whists124613813_whists
wists86728523__wists
wrists95415643_wrists
wursts95211163wu_rsts

Search took 8 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272077.20318607.1
3Display Results2072070.0802587.5
 (SQL Overall)1786912077.42324072.6
 
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.