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

106 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
functor123520(None) 
functors1335741functors
factor11911462f_actor
function1337842function
actor71116083__actor
anchor113911973_anchor
auditor837313auditor
bunco94616083bunc_o_
buncos104011593bunc_os
bunter85020383bun_ter
cantor85621523can_tor
coactor1139133coactor
cunctator1343923cunctator
curator9312213curator
doctor938993_doctor
donator8310263donator
eductor1035863eductor
effector1644873effector
ejector16378603ejector
elector93313263elector
emunctory1642653emunctory
enactor938043enactor
erector93513813erector
evictor12346363evictor
exactor1636633exactor
factors12912133f_actors
factory15108353f_actory
fancier123412063fancier
fantod102010033fan_tod
fantom112110803fan_tom
fencer114613533fenc_er
fetor81214533f__etor
finito9310303finito_
foetor939563f_oetor
fractur12135573fractur
fucker153414423fu_cker
fugato1036223fugato_
fugatos1135483fugatos
fumatory1644923fumatory
fumitory1643893fumitory
functions1437743functions
funder104016083fun_der
funfair1342033funfair
fungo94413133fun_go_
funker133915763fun_ker
funkier14349983funkier
funner93414103fun_ner
funnier103210173funnier
furor8312393fu__ror
futon83113773fu__ton
genitor837273genitor
hector113312653_hector
hunter94817773hun_ter
ignitor8125263ignitor
janitor1436483janitor
junco144612203junc_o_
juncos15449233junc_os
junction1736203junction
juncture1743903juncture
junior1386143jun_ior
junto125114563jun_to_
juntos134110843jun_tos
lector83514993_lector
lictor83610863_lictor
luncher123111413luncher
mentor8414363men_tor
monitor9310723monitor
mucor94011943mu_c_or
muncher143610373muncher
munster93710523munster
nonactor1047783nonactor
nuncio837973nuncio_
nuncios937113nuncios
proctor11310433proctor
puncher143311673puncher
puncture1245053puncture
punitory1345603punitory
punster92911103punster
punter84320023pun_ter
punto75121323pun_to_
puntos85915793pun_tos
questor16146633questor
quittor16285603quittor
rancor8810373ranc_or
reactor93011663reactor
rector84019753_rector
sector83415933_sector
senator7313073senator
succor1036623su_ccor
suitor63311053su_itor
tractor9311343tractor
tutor5712493tu__tor
unclog956603_unclog
unco66021403_unc_o_
uncool8610113_uncool
uncork1239043_unc_ork
uncos74117033_unc_os
uncoy104111413_unc_oy
unction9310663_unction
uniter64619143_uniter
unmoor836313_unmoor
unstop837473_unstop
unto45824283_un_to_
untorn63012343_un_torn
vector113212063_vector
victor113210673_victor

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.390458182.1
2DLD Change Limit1340271066.56320421.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.99925530.9
 
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.