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 “arborist” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
arborist1041161(None) 
arborists1147451arborists
amorist9317642a_morist
aorist64827872a__orist
aphorist13412512aphorist
arbalist10313332arbalist
arbores94016032arbores_
arborize1988962arborize
arbors84717882arbor_s_
arsonist8412012arsonist
ableist9311773a_bleist
abolish12311503a_bolish
abort76133583a_bor__t
aborts84916183a_borts_
abris75722603a_b_ris_
actorish1349443actorish
afforest1446343afforest
agonist82615403a_gonist
airburst1044233airbur_st
algorism1147353algorism
altoist7313393alto_ist
ambaris113112163ambaris_
amorists10411333a_morists
aorists74215833a__orists
aphorise1339983aphorise
aphorism1548643aphorism
aphorists1448263aphorists
apiarist10412063apiarist
aquarist171010083aquarist
arbalest1039523arbalest
arbalists1148483arbalists
arbelest1049503arbelest
arbor74818113arbor___
arboreal1045633arboreal
arbored103811603arbor_ed
arboreta1045223arboreta
arborized2166973arborized
arborizes2088823arborizes
arborous1047723arborous
arbours93910043arbours_
archaist1349863archaist
ardors74416873ardor_s_
armorial1049453armorial
armories10313653armories
armoring1149123armoring
armors85017813armor_s_
armrest9310163ar_mrest
aroint6328153ar_o_int
arrest63722633ar__rest
arris56824683ar__ris_
arsonists947413arsonists
artist64125543ar__tist
atomist92915763a_tomist
aurist65027253a__urist
aviarist11410113aviarist
barbarism1545963barbarism
carboras12311583carboras_
carburise1345813carburise
careerist1148793careerist
colorist102818993colorist
florist10314243_florist
harboring1538263harboring
harbors12412413harbor_s_
harmonist141310663harmonist
humorist1348783humorist
ironist7314843ir_onist
jargonist1746703jargonist
motorist10314413motorist
oboist8312683_obo_ist
parodist11412763par_odist
protist9320223pr_otist
rigorist949123rigorist
sarodist9510923sar_odist
tenorist8413023tenorist
terrorist988563terrorist
theorist1149553theorist
urbanist10109073urbanist

Search took 7 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.423422437.4
2DLD Change Limit146162776.45322650.2
3Display Results77770.0302566.7
 (SQL Overall)178691776.90625874.7
 
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.