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

43 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
twibill124274(None) 
twibil1133561twibi_l
twibills1342321twibills
twibils1253111twibils
tibial849842t_ibial
twill85612722tw__ill
bill67239943___bill
hawkbill2042223hawkbill
misbill1137033misbill
prebill1138803prebill
rebill84713253_rebill
sawbill1255293sawbill
stibial946583stibial
swill83417373sw__ill
thill85918733t__hill
thrill94910593t_hrill
tibia7312403t_ibi_a
tibiae838483t_ibiae
tibias839953t_ibias
tidily102811393t_idily
till45941203t___ill
tinily94014433t_inily
tribal8611133trib_al
tribally1347323tribally
tribals9610753tribals
trill55122933t__rill
trivial1038713trivial
twiddle12305483twiddle
twiddly15233773twiddly
twilit949553twili_t
twills9489793twi_lls
twinier1037313twinier
twining113211443twining
twinkle1464773twinkle
twinkly1733913twinkly
twirl85011943tw__irl
twirls9478123twi_rls
twirly12427083twi_rly
waxbill1943133waxbill
waybill1543723waybill
wilily123310763_wilily
will75737513_w__ill
wirily123310783_wirily

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 Limit134027436.25021444.3
3Display Results43430.000 
 (SQL Overall)178691436.65626846.6
 
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.