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

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

80 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
flitters11431217(None) 
fitters104517751f_itters
flatters113814201flatters
flirters11337931flirters
flitter103413901flitter_
flutters114010821flutters
fritters113810781fritters
glitters93710541glitters
litters73422571_litters
slitters84014131slitters
bitters94920362_bitters
blatters104414092blatters
blisters104015082blisters
blithers134711232blithers
blitzers19417152blitzers
blotters104110982blotters
chitters133711172chitters
clatters103313912clatters
clutters103210352clutters
critters103511322critters
emitters10349642emitters
fainters11349692fainters
fetters103517902f_etters
filisters1237002filisters
filters103816552f_ilters
fitter94120032f_itter_
flattens11357482flattens
flatter103815962flatter_
flattery14338292flattery
flichters1774172flichters
flickers17338882flickers
fliers94417192fli__ers
flinders12439262flinders
flingers123410192flingers
flippers15338002flippers
flirter10318672flirter_
flites95122442fli_te_s
flitted114011642flitte_d
flittered13196252flittered
flivvers1733112flivvers
floaters112711512floaters
flouters11419272flouters
flusters113811502flusters
fluters103713682fl_uters
flutter104012092flutter_
fluttery14376142fluttery
flytiers14254482flytiers
fretters113410302fretters
fritter103912772fritter_
glisters93912602glisters
glitter84211802glitter_
glittery12375612glittery
gritters94210632gritters
hitters104717592_hitters
jitters144314472_jitters
klisters123910482klisters
knitters12336622knitters
letters73819852_letters
lifters104313782_lifters
linters73822632_linters
listers74026532_listers
liters65429882_li_ters
litter64324852_litter_
littery103710492_littery
lotters73921062_lotters
omitters10277652omitters
platters103415282platters
plotters104011552plotters
quitters17238522quitters
ritters74020622_ritters
sitters74221552_sitters
skitters12349552skitters
slithers114212952slithers
slitter73615872slitter_
slotters84012402slotters
spitters104113382spitters
splitters11307322splitters
titters74219622_titters
twitters11296772twitters
whitters14359402whitters

Search took 4 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 Filter1786911210590.376475242.0
2DLD Change Limit121059803.15638358.4
3Display Results80800.0302666.7
 (SQL Overall)178691803.56250165.9
 
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.