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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
transfer113842(None) 
transfers1238041transfers
cotransfer1582422cotransfer
retransfer1352472retransfer
transfect1446732transfect
transferal1355702transferal
transferee1347242transferee
transferor1394522transferor
transfix1844982transfix
transform1446192transform
trasher104416122tra_sher
answer936893__answer
brander103915823bran_der
branner94212373bran_ner
brannier10218933brannier
brasher124515233bra_sher
brasier94516753bra_sier
brassier103310533brassier
cotransfers1672633cotransfers
cranker133612783cran_ker
crankier14339163crankier
crasher124616153cra_sher
crasser94114333cra_sser
dragster1034623dragster
eraser64216333era_s_er
franker143510183fran_ker
grander93315873gran_der
granger93514213gran_ger
granter84117133gran_ter
grasper10389783gra_sper
grassier9349283grassier
orangier947703orangier
praiser93413943prais_er
prancer113613383pran_cer
prankster1543183prankster
raiser66620103_rais_er
rancher123013633_rancher
randier83618473_randier
ranger73925523_ran_ger
rangier83714353_rangier
ranker105021903_ran_ker
ransomer1047883_ransomer
ranter63826823_ran_ter
raser55633413_ra_s_er
rasher95024113_ra_sher
rasper83917323_ra_sper
raster64731443_ra_ster
retransfers1452613retransfers
rinser64317213_rins_er
strafer103912443stra__fer
strander97112053stran_der
stranger94715083stran_ger
strangler10369463strangler
tanager83010943t_anager
tangier83013903t_angier
tangler83515073t_angler
tanker104521123t_an_ker
tanner63722283t_an_ner
tansies74521243t_ansies
tapster9299273t_apster
tarsier74119253t_arsier
taster64930573t_a_ster
teamster1036293teamster
teaser65421523tea_s_er
teensier835573teensier
tenser64919433t_ens_er
thanker14309593than_ker
thrasher1455733thra_sher
toaster74414463toa_ster
tracer84820233tra__cer
tracker133515173tra_cker
trader75218753tra__der
traducer1144583traducer
trailer73015393tra_iler
trainer73316793tra_iner
tramper113812153tra_mper
trampier12318233trampier
trampler12278003trampler
trance84718763tran_ce_
tranced104414173tran_ced
trances93919643tran_ces
tranche123312223tranche_
tranches132915513tranches
trannies8415013trannies
trans54933043trans___
transact1049823transact
transcend1246443transcend
transducer1354453transducer
transect10410053transect
transept1048633transept
transfects1545723transfects
transferals1455213transferals
transferase1455453transferase
transferees1456073transferees
transferors1484483transferors
transferred1554603transferred
transferrer1454693transferrer
transferrin1454763transferrin
transfixed2144763transfixed
transfixes2046473transfixes
transfixt1955833transfixt
transformer1654873transformer
transforms1545813transforms
transfuse1246013transfuse
transfused1444863transfused
transfuses1346743transfuses
transgene1047943transgene
tranship13410183tranship
transient9713213transient
transit7317163trans_it
transited10410603transited
transits8313493transits
transmit10410903transmit
transom948823trans_om
transoms1048933transoms
transpire1148853transpire
transport1149743transport
transude947083transude
transuded1145473transuded
transudes1047583transudes
transverse1345893transverse
trapper113912793tra_pper
trashed113514693tra_shed
trashers113013623tra_shers
trashes104119253tra_shes
trashier113210093trashier
trasses74819323tra_sses
traveler11328433traveler
trawler104011903tra_wler
trencher13279313trencher
trendier937913trendier
tressier847963tressier
troffer13125863tr_offer
trouser73812463trous_er
trundler9256143trundler
trusser74010253tr_usser
truster73114313tr_uster
tryster10369513tr_yster
twanger11327433twan_ger
twangier1254243twangier
twangler1244113twangler
wrangler1245473wrangler

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.1561145455.1
2DLD Change Limit1461621428.36017483.5
3Display Results1421420.0463087.0
 (SQL Overall)1786911428.56220870.2
 
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.