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

107 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
funplex193283(None) 
duplex16386972du_plex
fourplex2042092fourplex
funplexes2141982funplexes
auspex1574793ausp_ex
bundle94315573bundle_
bundled114011303bundled
bundler104011723bundler
bundles103515773bundles
bungle97116113bungle_
bungled114112243bungled
bungler104611483bungler
bungles104116763bungles
complex2037243complex
culex144613933cu__lex
diplex16408053_diplex
duple85315863du_ple_
finale94116763finale_
finales104016013finales
fipple13329063fipple_
fipples14298653fipples
flex146123473f___lex
fondle104412943fondle_
fondled12399423fondled
fondler11348883fondler
fondles113512613fondles
fuddle113312103fuddle_
fuddled13309393fuddled
fuddles123611933fuddles
fueled104913603fu_eled
fueler94313933fu_eler
fuelled11369193fuelled
fueller10279963fueller
fugle94915543fu_gle_
fugled114813693fu_gled
fugles104715783fu_gles
fulled103820653fu_lled
fuller94220383fu_ller
fumble133214263fumble_
fumbled153710493fumbled
fumbler143610813fumbler
fumbles143514413fumbles
funded114413893fun_ded
funder104016083fun_der
fungoes11388813fungoes
funicle12237483funicle_
funicles13246833funicles
funked144214113fun_ked
funker133915763fun_ker
funkier14349983funkier
funned103613953fun_ned
funnel93610743fun_nel
funneled1254873funneled
funnels10348173funnels
funner93414103fun_ner
funnier103210173funnier
funnies104113603funnies
furled104717053fu_rled
furler93616403fu_rler
fusile94313493fusile_
futile93914953futile_
gunplay1343233gunplay
jungle144012653jungle_
jungled16349643jungled
jungles154112543jungles
lunule638433lunule_
lunules738953lunules
nuncle839363nuncle_
nuncles939843nuncles
perplex1836153perplex
plex137321373___plex
pungle94413573pungle_
pungled114210083pungled
pungles104013713pungles
purple102712683purple_
purpled12299783purpled
purpler11289273purpler
purples112712833purples
quadplex2742083quadplex
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
rundle73214233rundle_
rundles83214713rundles
rundlet83114153rundlet
runkle103611543runkle_
runkled12399013runkled
runkles114111943runkles
runlet63821413run_let
simplex18256393simplex
supple10410203supple_
suppled1248463suppled
suppler1148433suppler
supples11511283supples
triplex16447803triplex
uncle7317053_uncle_
uncles8317163_uncles
unisex1358353_unisex
unled64021073_un_led
unlet54133333_un_let
unpeg8309363_unp_eg
unpen72913573_unp_en
unpile81914323_unpile_
unpiled102312743_unpiled
unpiles92112783_unpiles
unplug954413_unplug
unsex123512633_un_sex

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271076.94019312.2
3Display Results1071070.0303566.7
 (SQL Overall)1786911077.39024180.1
 
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.