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

121 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
conferees1461062(None) 
conferee13613731conferee_
conferrees1546101conferrees
conferences1898812conferences
conferred1537752conferred
conferree1447792conferree
conferrer1447062conferrer
conferrers1546452conferrers
confers124120092confer__s
confervas1744822confervas
confesses1438622confesses
confreres1448032confreres
congeries12316402congeries
conserves14311192conserves
converges1538382converges
converses14311162converses
bonfires1367383bonfir_es
canneries11313083canneries
cockerels1784673cockerels
coerces11311943co__erces
coffees15329573co_f_fees
coffered1737673coffer_ed
coffers154112693coffer__s
coffrets1645363co_ffrets
coherers132310733co_herers
coheres122917693co_her_es
coinferred1643893coinferred
coinfers13349503coinfer__s
coinheres1447633coinher_es
comfreys1843333comf_reys
commerces17147233commerces
comperes143217973comper_es
conceders1437953conceders
concedes13311063conce_des
conceives1639233conceives
concerned1438643concerned
concerns122710833concer_ns
concerted14312113concerted
concertos132711133concertos
concerts123016063concer_ts
concierges1544553concierges
concretes13411473concretes
condenses12710133condenses
condores113315643condor_es
confected1739073confected
confects153110873confe_cts
confer114018683confer___
conference1799013conference
conferment17410373conferment
conferments1848323conferments
conferral1446323conferral
conferrals1545403conferrals
conferrences19106073conferrences
conferva1644433confer_va
confervae1745143confervae
conferval1745563conferval
confess12399903conf__ess
confessed1546053confessed
confiders1537483confiders
confides14310573conf_ides
confiners1439953confiners
confines13315653conf_ines
confirmed1745563confirmed
confirmer1665663confirmer
confirmers1744963confirmers
confirms1536303confir_ms
conflates14311133conflates
confluxes2143833confluxes
conformed1767463conformed
conformer1667463conformer
conformers1746553conformers
conforms1538873confor_ms
confrere1347563conf_rere
confuses13310363conf_uses
confuters1437793confuters
confutes1339843conf_utes
congees103517923con__gees
congeners122511133congeners
congers104223233conger__s
congress1138073con_gress
coniferous1545443coniferous
conifers133611703conifer__s
conjurers18126233conjurers
conjures17119913conjur_es
conkers133721043conker__s
conners94023113conner__s
conquerers2144223conquerers
conserve1339933conserve_
conserved1538853conserved
conserver1448723conserver
conservers1547683conservers
construes11410133construes
conveners142911443conveners
convenes132916913conve_nes
converge1437393converge_
converged1636973converged
converse13310263converse_
conversed1538683conversed
converser1438093converser
conversers1547353conversers
conversos1446893conversos
converted15311563converted
converter14311013converter
converters1539633converters
converts133213553conver_ts
convexes20278273conve_xes
conveyers17267203conveyers
cookeries151210633cookeries
cooperies131113313cooperies
coteries10422703co_teries
counselees1244083counselees
coverers132712123co_verers
honorees1148773hon_orees
monkeries15129913monkeries
nonheroes1247633nonheroes
offerers1434933_offerers
ponderers12248453ponderers
referees111310413_referees
rooftrees1242403rooftrees
unfrees1048643_unf_rees
wonderers13217933wonderers

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411216.97021325.8
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.45623966.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.