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

123 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
fiancees133510(None) 
fiancee1238951fiancee_
fiances12310671fianc_es
fancies124018782f_ancies
fiacres1237252fia_cres
fiance11310742fianc_e_
fiascoes13134922fiascoes
finances1338652financ_es
finches153914192fi_nches
affiances1745153affianc_es
blanches153311603blanches
branches153613803branches
cancels114113313_cancels
cancers114018583_cancers
chancels15439083chancels
chancers154313493chancers
chances145218093chanc_es
chancres15429363chancres
cinches144215773ci_nches
cranches153114543cranches
dancers103413093_dancers
dances95120653_danc_es
defiances1557033defianc_es
facers115519443f_a_cers
faces106439433f_a_c_es
facets116316653f_a_cets
facies113921593f_a_cies
faeces114713123f_aec_es
faiences1337043faienc_es
fainters11349693fainters
falces115216003f_alc_es
fancied133310603f_ancied
fancier123412063f_ancier
fanciers13358083f_anciers
fanciest133612713f_anciest
fanes84639893f_an__es
fanjets1734803f_anjets
fanners103914653f_anners
fannies103415643f_annies
farcers124713443f_arcers
farces115223323f_arc_es
farcies125317883f_arcies
fasces114914543f_asc_es
fauces114916153f_auc_es
faucets12578443f_aucets
fencers123810623f_encers
fences114617113f_enc_es
fiacre1137623fia_cre_
fiascos12124743fiasc_os
fices106031163fi__c_es
fiches145219533fi__ches
ficoes114613463fi__coes
filagrees1373883filagrees
filarees1187643filarees
filches153410723fi_lches
finagles12237553finagles
finales104016013fi_nales
finance1238573financ_e_
financed1435113financ_ed
financier1443713financier
financiers1542383financiers
fincas113512073fi_nc_as
finders113717873fi_nders
fines86644263fi_n__es
fingers113418433fi_ngers
finises10312903fi_nises
finites10315923fi_nites
finless102810783fi_nless
fitches153516193fi_tches
fitness10299393fitn_ess
flanes94522423flan__es
flangers123311373flangers
flanges113413273flan_ges
flankers15349303flankers
flannels1134843flannels
flenches163410533flenches
flinches16358953flinches
francizes2346793francizes
francs114112193franc__s
frankers15348353frankers
frenches163311633frenches
giantess933893giantess
glancers11408003glancers
glances104113143glanc_es
grandees103211283grandees
grantees92510973grantees
hances115621283_hanc_es
inches114419673_i_nches
lancers93616643_lancers
lances84824103_lanc_es
lancets93411163_lancets
lianes63819323lian__es
licencees13134643licencees
manches143818623_manches
mincers113714853mi_ncers
minces104420803mi_nc_es
nances83618643_nanc_es
nancies93516843_nancies
nuances938523nuanc_es
painches1588913painches
pincers113916503pi_ncers
pinches144117933pi_nches
planches153111863planches
pliancies1346673pliancies
prancers123210333prancers
prances113618773pranc_es
rances84625443_ranc_es
ranches123620113_ranches
ranees64623963_ran_ees
seances93015343seanc_es
signees83510803sign_ees
spancels1245273spancels
stances93715963stanc_es
stanches132312793stanches
standees93310143standees
trances93919643tranc_es
tranches132915513tranches
usances967373usanc_es
whangees15275063whangees
wincers123415363wi_ncers
winces114819113wi_nc_es
winceys15395523wi_nceys
winches154714373wi_nches

Search took 8 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 Limit1461621237.39019778.3
3Display Results1231230.0631952.4
 (SQL Overall)1786911237.60923484.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.