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 “whifflers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
whifflers214277(None) 
whiffers2064491whiff_ers
whiffler2033481whiffler_
whiffles2034261whiffle_s
rifflers14336442_rifflers
shufflers18265152shufflers
snifflers15275052snifflers
wafflers17306322w_afflers
whiffer19105322whiff_er_
whiffets2072522whiff_ets
whiffle1933532whiffle__
whiffled2133042whiffle_d
whirlers14286052whi_rlers
whistlers1595162whistlers
whittlers1594332whittlers
bafflers16356593_bafflers
chaffers19378003chaff_ers
chillers133710923chi_llers
chiselers1445453chiselers
differs14339973_diff_ers
higglers13297233_higglers
hillers103718733_hi_llers
mufflers16316003_mufflers
niffers13287363_niff_ers
piffles15368763_piffle_s
rafflers14317363_rafflers
riffler13328353_riffler_
riffles133911163_riffle_s
riflers103512193_ri_flers
rufflers14347193_rufflers
scufflers17285033scufflers
shifters14319863shi_fters
shiftless15265303shiftless
shinglers13246443shinglers
shuffler17306803shuffler_
shuffles17297783shuffle_s
siffleurs1541643_siffleurs
skiffles18265713skiffle_s
skiffless19243053skiffless
sniffers14257123sniff_ers
sniffler14296833sniffler_
sniffles14257723sniffle_s
snufflers15285223snufflers
stiflers11238833sti_flers
triflers113110213tri_flers
waffler16377783w_affler_
waffles16329983w_affle_s
wailers103916803wai__lers
whalers13529703wh__alers
wheedlers1643203wheedlers
wheelers14287743wh_eelers
whickers20297983whi_ckers
whiffed2064473whiff_e_d
whiffet1965343whiff_e_t
whiffletree2361133whiffletree
whiffletrees246813whiffletrees
whiffling2242883whiffling
whiffs1835083whiff___s
whiles124418013whi__le_s
whimpers18276613whi_mpers
whiners134011573whi__ners
whingers15358723whi_ngers
whippers18329043whi_ppers
whirler13307603whi_rler_
whiskers18306773whi_skers
whispers16266993whi_spers
whistler1496313whistler_
whistles14108213whistle_s
whiteners1535253whiteners
whitters14359403whi_tters
whittler1495193whittler_
whittles1496673whittle_s
whizzers2233423whi_zzers
wifeless14277483w_ifeless
wigglers13257213w_igglers
willers103517913w_i_llers
wrigglers14273713wrigglers

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 Filter1786911486410.436409841.7
2DLD Change Limit148641776.90621523.5
3Display Results77770.0461673.9
 (SQL Overall)178691777.38824186.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.