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

119 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
nitwits103505(None) 
nitwit938591nitwit_
dimwits1344512dimwits
intuits7310312intuits
intwist1038042intwist
intwists1145592intwists
nitrids8269632nitrids
nitrils72810702nitrils
nitrite72314462nitrite
nitrites82313452nitrites
outwits103110862outwits
titbits935802titbits
twits86015792__twits
attrits7310613attrits
bigwigs1443003bigwigs
binits85716673bi_nits
bitts75022593bit__ts
cities84524853cit_ies
citrins92614363citrins
digits84114533di_gits
dimwit1237953dimwit_
ditties83116983ditties
dixits144210313di_xits
entwist1048803entwist
entwists1156143entwists
godwits1234133godwits
intents72115703intents
intis55121643int_i_s
intorts7310973intorts
introits859713introits
intuit6314083intuit_
intwine1038513intwine
intwines1138043intwines
iwis77117013_i_wi_s
kitties113213623kitties
kiwis12328583ki_wi_s
limits82514143li_mits
lithias1038823lithias
misfits12279663misfits
mishits122513083mishits
mitis75425993mit_i_s
mitts75523753mit__ts
netts55320723net__ts
newies91014073n_ewies
newts86015283n_ew_ts
niacins938543niacins
nidgets9358143nidgets
nifties102612503nifties
nights104117723ni_ghts
nihils937573ni_hils
ninnies73713613ninnies
niobite937953niobite
niobites1037313niobites
niseis63512023nisei_s
nitchies1339073nitchies
niteries8318383niteries
niters64624213nit_ers
nites55736343nit__es
nitid61817833nit_i_d
nitons64614903nit_ons
nitpick1543783nitpick
nitpicks1643183nitpicks
nitrate72017013nitrate
nitrates82516223nitrates
nitres65519333nit_res
nitric82512063nitri_c
nitrid72812233nitri_d
nitride82811243nitride
nitrides92910703nitrides
nitrify1335793nitrify
nitril62511533nitri_l
nitrile73011373nitrile
nitriles8269923nitriles
nitros64214123nit_ros
nitrous73512483nitrous
nits45741643n___its
nittier73512243nittier
nittiest82712603nittiest
nitty85418313nit__ty
nixies135313873ni_xies
nowts86915863n_ow_ts
nutlets74111253nutlets
nutrias739813nutrias
outfits102210833outfits
outhits102213503outhits
outsits73215253outsits
outwaits1137493outwaits
outwit93014593outwit_
outwith13279133outwith
peewits12105873peewits
pewits112810683_pewits
pipits104713063pi_pits
pities83828083pit_ies
retwist1039483retwist
retwists1135603retwists
tidbits1035183tidbits
titbit839823titbit_
titis56023813tit_i_s
titlist7312923titlist
titlists837293titlists
tits46145043__t_its
titties73617363titties
toits55327473__toits
twats86616603__twats
twigs96911173__twigs
twins85118983__twins
twist86820983__twist
twists9549753__twists
twit76329063__twit_
unities72520153unit_ies
untwist1047713untwist
untwists1144623untwists
unwits9389893_unwits
visits9311423vi_sits
vitrics12198553vitrics
withies133913543withies
withins133511693withins
wits76044873___wits
zitis145815583zit_i_s

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.403443402.0
2DLD Change Limit1340271196.87619492.0
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.32524394.7
 
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.