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

99 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
tribally134732(None) 
bridally1446452bridally
ribaldly1442812_ribaldly
tidally1137932t_idally
trevally1446342trevally
tribal8611132triba_l_
tribals9610742triba_ls
trivially1545142trivially
aerially11911913aeri_ally
animally1368643animally
apically1539823apically
areally10411243ar_eally
axially1737233axi_ally
bally105530103___bally
bribable1137223bribable
brutally1345743brutally
clinally1347233clinally
coitally1339483coitally
dribbly15274953drib_bly
epically15310573epically
ethically1748693ethically
finally13310103_finally
friarly13316213fri_arly
frilly124111443fri__lly
frugally1544403frugally
globally1444613globally
labially1336983labially
laically1338983laically
lyrically1746763lyrically
maritally1448223maritally
metrically17411073metrically
misally121111063_misally
orally93113593or__ally
ordinally1346283ordinally
probably1746413probably
rally84725903_r__ally
really93315613_r_eally
regally1159873_regally
retally10413683_retally
ribald9209293_riba_ld
ribaldry1441703_ribaldry
ribalds10236673_ribalds
ritually1167483_ritually
rivalry1354033_rivalry
royally13157733_royally
rurally1038293_rurally
serially11912833seri_ally
spinally1338013spinally
spirally1348013spirally
sterically15410463sterically
stoically1449643stoically
tally84526863t___ally
tarnally1138273tarnally
telically1449853telically
terminally1567023terminally
tonally10311373t_onally
tonically14311123tonically
topically1649523topically
toroidally1444063toroidally
totally1039893t_otally
toxically2147563toxically
tragically1648863tragically
trapball1244753trapball_
trapballs1344183trapballs
treacly1237093tr_eacly
trebly1138973treb__ly
trevallys1542213trevallys
triable92515393tri_able
trial54926353tri_a_l_
trials64319883tri_a_ls
tribade1037283triba_de
tribades1136883tribades
tribadic1344083tribadic
tribalism1347893tribalism
tribalist1149953tribalist
tribasic1244783tribasic
tribology1545123tribology
trickily1736233trickily
trickly16369893tri_ckly
trigly103810943tri__gly
trigonally1454053trigonally
trilby1144973tri__lby
trill55122933tri__ll_
trills64319853tri__lls
trimly114410893tri__mly
trinal6516953trina_l_
trinary1039163trina_ry
triply114211023tri__ply
tritely1039003tri_tely
trivalve1443943trivalve
trolly94012353tr__olly
tropically1749823tropically
twibill1242743twibill_
twibills1342323twibills
typically1946073typically
verbally1647183verbally
virally1339643_virally
vitally1339673_vitally
xerically2149523xerically

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.203880251.2
2DLD Change Limit146162998.23617746.7
3Display Results99990.0303300.0
 (SQL Overall)178691998.46921099.4
 
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.