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

111 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
misbill113703(None) 
misbills1246081misbills
distill83011322distill
misbias1139082misbias
misbilled1445172misbilled
misbind1258272misbind
misbuild1343162misbuild
misbuilt1245092misbuilt
miscall1139652miscall
misdial1039642misdial
misfile122611552misfile
missile92815402missile
mistily122612342mistily
bill67239943___bill
distil73616433disti_l
distills9319043distills
distils83015803distils
fishily1637643fishily
fishkill1842143fishkill
fissile10269653fissile
infill938413_infill
instill789063instill
maill74420793m__aill
mesial84818083mes_ial
messily12298813messily
micell1098193mi_cell
milkily16216553milkily
mill66541483m___ill
minimill1244483minimill
minipill1244353minipill
mirkily16266403mirkily
misaim10311853misai_m
misaims11310113misaims
misally121111063misally
misbilling1545543misbilling
misbinds1345163misbinds
misbuilds1442393misbuilds
miscalls1239003miscalls
miscible1447673miscible
miscite11314383miscite
misdeal1037663misdeal
misdials1137493misdials
misdid10510573misdi_d
miserly12329823miserly
misfield14265913misfield
misfiled14278653misfiled
misfiles133110983misfiles
misfire12229893misfire
misfit112813833misfi_t
misfits12279663misfits
misgive13339033misgive
mishit112618203mishi_t
mishits122513083mishits
miskal123710263mis_kal
miskals13369763miskals
miskick1435613miskick
mislie83219153misli_e
mislies92922283mislies
mislike132914833mislike
mislit83019693misli_t
mislive122812693mislive
misrely12319613misrely
misrule939353misrule
missal84314903mis_sal
missals93914423missals
missel85216523mis_sel
missels94614813missels
missies93423983missies
missiles103015083missiles
missilry1344653missilry
missing103619073missing
mission9312743mission
missis84417503missi_s
missive122413143missive
misspell1244303misspell
mistier93418713mistier
mistime11312613mistime
misting103623383misting
mistitle1038523mistitle
mistral91013643mistral
mistrial10311383mistrial
mixible18195093mixible
mobile103613543m_obile
morbilli1244963morbilli
mudsill1045163mudsill
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
pinball1137933pinball
pistil83915073pisti_l
pistils93314303pistils
prebill1138803prebill
rebill84713253_rebill
risible937923risible
risibly1235643risibly
riskily1436413riskily
sawbill1255293sawbill
shill85325333__shill
sill45545153__s_ill
skill94316723__skill
spill74821163__spill
still54922083__still
swill83417373__swill
tibial849843ti_bial
twibill1242743twibill
visible1236923visible
visibly1535043visibly
waxbill1943133waxbill
waybill1543723waybill
wispily1535653wispily

Search took 7 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.406440125.6
2DLD Change Limit1340271115.75323296.9
3Display Results1111110.0432581.4
 (SQL Overall)1786911116.20228811.8
 
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.