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 “bortz” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
bortz16572220(None) 
bort65960961bort_
borts76735451borts
borty105522831borty
abort76133582abort_
aborts84916182aborts
aorta55922572aorta
berth104917882berth
birth105619872birth
blitz165318132blitz
boart78835932boart_
boarts84716872boarts
boat66360312boat_
boats75635152boats
boite74426322boite
bolt66254172bolt_
bolts76232112bolts
boot67759372boot_
booth105522012booth
boots75837972boots
booty106125912booty
bora66141632bor_a
boral75831702boral
boras75938302boras
borate85026152borate
borax145918722borax
bore66051332bor_e
bored85034302bored
borer75131272borer
bores76448252bores
boric98024222boric
bork106933822bor_k
borks115727702borks
born67338412bor_n
borne77926792borne
boron76727142boron
bortzes1838222bortzes
bot59680402bo_t_
bota66236502bo_ta
both96533432bo_th
bots66453952bo_ts
bott66548572bo_tt
botts75224862botts
bout66353292bout_
bouts75131312bouts
broth106521092broth
dorty96220812dorty
fort76456442fort_
forte86131462forte
forth116222672forth
forts86034452forts
forty114824272forty
hertz174919042hertz
mort66758832mort_
morts75533562morts
nertz145117452nertz
north86018272north
ort39465232_ort_
orts46538332_orts
port66059632port_
ports75934592ports
sort46264812sort_
sorta57125412sorta
sorts54536662sorts
tort46967462tort_
torta55925352torta
torte55431702torte
torts56138122torts
wort76654752wort_
worth117120522worth
worts88631182worts

Search took 2 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 Filter178691538000.330541487.9
2DLD Change Limit53800711.48336277.8
3Display Results71710.0302366.7
 (SQL Overall)178691711.84396956.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.