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

68 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
tranships1441033(None) 
tranship13410191tranship_
transships1546781transships
deanships1545992deanships
tankships1844642t_ankships
thaneships1854392thaneships
townships1744982townships
transits8313502trans_its
transmits1149272transmits
transship1446452transship_
twinships1744122twinships
airmanships1874463airmanships
arhatships1853923arhatships
banshies131110663_banshies
deanship1446563deanship_
dramshops1762583dramshops
earlships1444773earlships
flagships1843703flagships
gunships1445173_gunships
hardships1845653hardships
headships1845673headships
kinships1745793_kinships
palships1546213_palships
preships1539313pr_eships
reships1239863_r_eships
sonships1357463_sonships
starships1447663starships
steamships1754063steamships
tankship1744903t_ankship_
tansies74521243t_ans_ies
teashops1345733tea_shops
thaneship1754463thaneship_
tinsnips1043733t_insnips
township1645463township_
traineeships1762193traineeships
tranches132915513tranch_es
trannies8415013tran_nies
transacts1157363transacts
transcript1456473transcript
transcripts1554433transcripts
transects1157823transects
transept1048633trans_ept
transepts1146383transepts
transfers1238053transfers
transfix1844983transfi_x
transfixes2046473transfixes
transfixt1955833transfixt
transhipped1953073transhipped
transit7317163trans_i_t
transmit10410913transmi_t
transoms1048933trans_oms
transpire1148863transpire
transpires1249313transpires
transshape15134383transshape
transshapes1674313transshapes
transudes1047593transudes
trashers113013643tra_shers
trashes104119263tra_sh_es
trashier113210103tra_shier
trashiest123110643tra_shiest
trashily1437323tra_shily
trashing122613223tra_shing
troopships1753153troopships
twinship1644473twinship_
unships1237203__unships
upmanships1953713upmanships
wardships1844593wardships
warships1647553_warships

Search took 10 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 Filter1786911486410.423422437.4
2DLD Change Limit148641688.64017203.8
3Display Results68680.0302266.7
 (SQL Overall)178691689.09319651.5
 
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.