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

69 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
trances9391964(None) 
prances113618771prances
rances84625441_rances
traces85329931tra_ces
trance84718761trance_
tranced104414171tranced
tranches132915511tranches
braces108427772bra_ces
branches153613802branches
chances145218092chances
cranches153114542cranches
cranes84330752cran_es
dances95120652_dances
durances1158682durances
entrances11310952entrances
fiances12310672fiances
francs114112192franc_s
glances104113142glances
graces94523492gra_ces
granges93516522granges
hances115621282_hances
iterances1148902iterances
lances84824102_lances
nances83618642_nances
nuances938522nuances
oranges84215332oranges
outrances112912112outrances
prance104318572prance_
pranced123714042pranced
prancer113613382prancer
prancers123210332prancers
princes113015142princes
races74943242_ra_ces
rance75028512_rance_
ranches123620112_ranches
ranees64623962_ranees
ranges73826922_ranges
seances93015342seances
stances93715962stances
stranges94516762stranges
taces76237802t_a_ces
tenaces92814512tenaces
thanes94918982than_es
trace75829612tra_ce_
traced94821582tra_ced
tracer84820232tra_cer
tracers94917832tra_cers
tracks124818842tra_cks
tracts85019072tra_cts
trades75724492tra_des
traduces1136552traduces
trainees82712062trainees
tranche123312222tranche
tranks104017762tran_ks
trannies8415012trannies
tranqs155210312tran_qs
trans54933042tran__s
trapes85024462tra_pes
trashes104119252trashes
trasses74819322trasses
traves94222742tra_ves
trenches133512602trenches
trices84826332tr_ices
trines64132562trin_es
trones65629282tron_es
trounces1037052trounces
truancies1146872truancies
truces84916332tr_uces
usances967372usances

Search took 5 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 Filter1786911076710.1401276364.3
2DLD Change Limit107671693.96627148.5
3Display Results69690.0332090.9
 (SQL Overall)178691694.13943172.5
 
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.