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

76 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
diablery144323(None) 
diablerie1243582diablerie
dialer74315432dia_ler_
dialers83614302dia_lers
dialler848812dialler_
diallers957772diallers
dibbler124510282dibbler_
dibblers13377582dibblers
disabler1147912disabler_
disablers1255802disablers
abler75624313__abler_
bibbery13426543bi_bbery
cabler104519173_cabler_
cablers114416713_cablers
dabber114816963d_abber_
dabbers123813213d_abbers
dabbler124012153dabbler_
dabblers13379363dabblers
daubery13396213d_aubery
dealer74122143dea_ler_
dealers84118613dea_lers
deanery1137613dea_nery
diableries1344603diableries
dialect101210263dia_lect
dialed84716453dia_le_d
dialled9510133dialle_d
diallel845683dialle_l
diaper94513113dia_per_
diapers104713913dia_pers
diary95016973dia___ry
diaster82813313diaster_
diasters92913183diasters
diathermy1842573diathermy
dibber114614713di_bber_
dibbers124013173di_bbers
dibble114013843dibble__
dibbled133510843dibble_d
dibbles124013333dibble_s
diddler103511513diddler_
diddlers11359153diddlers
diddley13388103diddle_y
disable10516433disable__
disabled1248713disable_d
disables11410903disable_s
dithery14318943di_thery
doable93115243doable__
doubler103110083doubler_
doublers11288503doublers
drabber12438593drabber_
drably123511613drabl__y
drapery13387943dra_pery
drawler11338593drawler_
drawlers12307313drawlers
dribbler13316313dribbler_
dribblers14274453dribblers
drollery12314793drollery
dyable12308983dyable__
enabler9299363enabler_
enablers10196913enablers
fabler116115813_fabler_
fablers124812613_fablers
gallery11468743_gallery
liable81415813liable__
nibbler11379273nibbler_
nibblers12306543nibblers
nimbler11358063nimbler_
raillery1134953raillery
ribaldry1441703ribaldry
riflery13345803ri_flery
sealery104011053sea_lery
slabbery15375773slabbery
stabler94014933stabler_
stablers103611153stablers
timbery14256893timb_ery
viable111613773viable__
viably14199833viabl__y

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 Filter1786911461620.423422437.4
2DLD Change Limit146162767.29620033.2
3Display Results76760.0332303.0
 (SQL Overall)178691767.75223051.0
 
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.