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

65 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
taboulis104504(None) 
tabouli945841tabouli_
tabulis938831tab_ulis
aboulia966552_aboulia
aboulias1065532_aboulias
aboulic1156282_aboulic
tabouleh1342792tabouleh
taboulehs1441972taboulehs
tabours94110072tabou_rs
tabuli839362tab_uli_
abolish12311503_abo_lish
abounds10217083_abounds
abulia83512503_ab_ulia
abulias93210693_ab_ulias
abulic106411423_ab_ulic
agoutis8286863_agoutis
aiolis6316843_aio_lis
babools11319453babool_s
babuls105413643bab_ul_s
boules84925973__boules
caulis85320073ca__ulis
ciboules1244533ciboules
coulis84018753__coulis
fabulist1347673fab_ulist
kabukis1243193kab_ukis
labours9349883labou_rs
lazulis1634903la_zulis
pachoulis1643613pachoulis
tabbis102910853tab__bis
tabbouleh1651543tabbouleh
tabboulehs175923tabboulehs
tablas83716163tab__las
tables84524883tab__les
tabooley1342993tabooley
tabooleys1441733tabooleys
taboos83815423tabo__os
taborers10268333taborers
taborets10278063taborets
taborin92210453tabo_rin
taborins103310213taborins
tabors84517093tabo__rs
tabour84011313tabou__r
taboured1156273taboured
tabourer1035743tabourer
tabourers1144673tabourers
tabouret1049173tabouret
tabourets1144163tabourets
tabouring1245723tabouring
tabular9279763tab_ular
tabuns8489223tab_u_ns
tabus74820923tab_u__s
tallis63319963ta__llis
tambouras1343473tambouras
tambourin1363613tambourin
tambourins1443463tambourins
tambours1255863tambou_rs
tanukis1134713ta_nukis
tatouays1142563tatouays
taxols13328633taxo_l_s
teabowls1343463teabowl_s
tsouris735153t_souris
tubfuls1245473tubful_s
tubules9310233tub_ules
tubulin9116433tub_ulin
tubulins10106293tub_ulins

Search took 9 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.1701051123.5
2DLD Change Limit146162658.11018022.4
3Display Results65650.0302166.7
 (SQL Overall)178691658.31021503.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.